Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
vijayit43
Creator
Creator

Sorting Issue

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.............

4 Replies
jagan
Partner - Champion III
Partner - Champion III

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
Champion III
Champion III

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
Master III
Master III

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

Not applicable

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