topic Re: Sorting Issue in QlikView

Sorting Issue

vijayit43 — Mon, 21 Apr 2014 07:35:30 GMT

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

Re: Sorting Issue

jagan — Mon, 21 Apr 2014 07:46:53 GMT

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.

Re: Sorting Issue

its_anandrjs — Mon, 21 Apr 2014 07:51:22 GMT

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')

Re: Sorting Issue

anbu1984 — Mon, 21 Apr 2014 07:52:00 GMT

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

Re: Sorting Issue

Mon, 21 Apr 2014 07:54:15 GMT

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