topic Re: manipulating labels in the x-axis in QlikView

manipulating labels in the x-axis

Fri, 05 Dec 2014 10:34:07 GMT

Hi,

I have big integer keys on the x-axis, like 100032, 2000012 etc

Is there a way I could sort these and display just 1, 2, 3 and so on in order instead of their actual codes.. I still want these keys to work as they are working, I just want to have 1 instead of 100032, 2 instead of 2000012 etc for visualization purposes..

is there a way to achieve this?

Thanks!!

Re: manipulating labels in the x-axis

Gysbert_Wassenaar — Fri, 05 Dec 2014 11:02:58 GMT

Maybe by using something like dual( aggr(rowno(),MyDim),MyDim) as a calculated dimension.

Re: manipulating labels in the x-axis

Fri, 05 Dec 2014 11:09:17 GMT

Hi yukti,

try this

add calculated dimension like (your_dimension/100000)

then in numbers tab check the integer checkbox to display it as a whole value!

or else use symbols of million,thousands!

hope it helps!

Regards

Barathiraja

Re: manipulating labels in the x-axis

Fri, 05 Dec 2014 11:23:15 GMT

Hi Gysbert,

I thought it would work, but it aggregates everything and shows only one data point..

Re: manipulating labels in the x-axis

kushalthakral — Fri, 05 Dec 2014 11:37:01 GMT

Hi yukti

you can use left() function and use 1st digit of number to use it as a label in a script

Regards

Kushal T

Re: manipulating labels in the x-axis

Fri, 05 Dec 2014 11:40:57 GMT

hey no actually keys have different values as in they could also be like 1000806, 1000807, 1000808 and so on...

Re: manipulating labels in the x-axis

Fri, 05 Dec 2014 11:56:54 GMT

or maybe if there's a way I could display an expression on the x-axis?

Re: manipulating labels in the x-axis

Fri, 05 Dec 2014 12:03:52 GMT

You can use a map table which contains the dimension and a short form of the dimension. See the attached example

Re: manipulating labels in the x-axis

Fri, 05 Dec 2014 12:05:42 GMT

Use the short form of the dimension in your chart and it will show the correct values from the main table.

Re: manipulating labels in the x-axis

Fri, 05 Dec 2014 12:31:34 GMT

it might sound a little weird to understand, but this is the requirement.. no matter what the key is, the numbers should be displayed in sequence .. 1 for first key, 2 for second key, 3 for third key... and so on...

Re: Re: manipulating labels in the x-axis

Fri, 05 Dec 2014 13:21:19 GMT

Try the attached... notice that I have specified the Sort Order to be Numeric Ascending in the bar chart - so it is displaying in ascending order, even though the load order is different as shows in the table box on left. Hope this solves the problem.

Re: manipulating labels in the x-axis

stigchel — Fri, 05 Dec 2014 13:41:24 GMT

Yes you can, disable the show legend of the Dimension, add an expression (make it the first by promoting it) and in the display options check text on axis and deselect any other display options like bar/line/symbol.

For the expression you can use an expression that will give you the required numbering (rowno()/columnno(), rank(..))