topic Showing Dimension in a Particular Order in QlikView

Showing Dimension in a Particular Order

Thu, 21 Feb 2013 10:18:14 GMT

Within a pivot table I have a dimension called Group, which has the following headings:- Hardware, New Licences, New Support, Other, Renewed Licences, Renewed Support, Services & Software.

When I create the table it loads these in alphabetical order however I would like to show them in a specific way, i.e. Hardware, Software, New Licences, Services, New Support, Renewed Licences & Renewed Support.

Is it possible to specify a particular order you'd like dimensions to appear?

thanks

Iain

Re: Showing Dimension in a Particular Order

Anonymous — Thu, 21 Feb 2013 10:20:48 GMT

Hi,

You can change the order on the dimension tab of the chart properties by using the Promote and Demote buttons.

Re: Showing Dimension in a Particular Order

sushil353 — Thu, 21 Feb 2013 10:30:00 GMT

if all above mentioned name are in one dimention. then you can sort them using a flag field.

PFA.

hope that helps you

Re: Showing Dimension in a Particular Order

Thu, 21 Feb 2013 11:21:37 GMT

Hi,

In the sort tab of the pivot table , select the dimension ("group") and write a sort expression like below.

Thanks

=IF(GROUP=Hardware,1,
IF(GROUP=Software,2,
IF(GROUP=New Licences,3,
IF(GROUP=Services,4,
IF(GROUP=New Support,5,
IF(GROUP=Renewed Licences,6,
IF(GROUP=Renewed Support,7)))))))

Re: Showing Dimension in a Particular Order

Thu, 21 Feb 2013 12:06:28 GMT

Thank you, presumably I could put this is the document properties within settings and this will sort them in any future tables I create.

regards

Iain

Re: Showing Dimension in a Particular Order

Thu, 21 Feb 2013 12:07:39 GMT

Thank you, this was helpful but I'm going to go with umeshjadhav's reply

kind regards

Iain