Sorting Issue

[vijayit43]

In Qlik View Dashboard User Want to sort Dimension Field in Asscending Order and Expression Field in descindingOrder Its Possible Or Not If Possible Then How?, Please Help.............

[jagan]

Hi,

You can do any one way either sort Dimension Field in Asscending Order or Expression Field in descindingOrder, can you attach some sample file and expected output.

Regards,

Jagan.

[its_anandrjs]

At a time you can sort dimension or expression in ascending or descending order or depends on the dimension and expression.

You can create a sort order for that or also for the expression and then you use

Eg:-

Load * inline

[

Customer,SeqOrder

Mar,1

Feb,2

Jan,3

Apr,4

];

If you use SeqOrder for sorting then you sort on basis of the SeqOrder

Or in Dimension you can use

=Match(Customer,'Mar','Feb','Jan','Apr')

[anbu1984]

Yes possible. Select sorting order for your dimension and expression in Sort tab.

[#5]

Hi,

      when u r doing sorting on dimension i will be sorted by ascending order

     after will sort the data by expression level only the data will be appear in expression level sorting i.e; dimension data

automatically as per expression