Twitter/Facebook

Pinterest
Thursday, October 9, 2014



Hello Qlikviewers! 
We sometimes have a problem when the labels in the X axis is too big to be fitted in our chart properly. Let's see what we can do to make it more presentable. 



Let's consider my previous example, in which i explain the carriage return in a field problem Qlikview Carriage Return Post




Now I create a chart with 
Dimension: Films


Expression: Count(Films) 

In reality this doesnt make sense, as the no of films per film name will always be one for all films. But I am taking this example just to explain the wrap text concept. 

This is what happens, right? We dont get a kind of chart we want. 

Now let's make the text in X axis wrapped. 


Below is the result of wrapping the same content in the chart 2 above. 



change the dimension as below:
Dimension: =Replace(Film,' ',chr(13))
This will replace the spaces with chr(13) which is a carriage return so the text will look wrapped. 

Then n the Axes property change the primary label style to / as below.


Hope this was helpful. Like the page below to get more such updates. Contact me either in the contact form or by commenting below for any doubts. Not that i know, I will try to find it out for you and learn along with you. 

4 Scribbles:

  1. Hi This is all about A great tool for Data Visualization.....
    Qlikview Online Training

    ReplyDelete
  2. Excellent post!!! The strategy you have posted on this Selenium Training technology helped me to get to the next level and had a lot of information in it.Selenium Training in Chennai

    ReplyDelete
  3. This REALLY has helped me. Thank you!!

    ReplyDelete
  4. This works if the labels are 1 or two words long. My label is a sentence. I'm trying to split it at the nearest space to the 15th character.

    ReplyDelete

Thank You for taking pains, commenting :)

LinkWithin

Search This Blog

 
badge