Custom Sorting

[Hercules64]

Hello,

I created a variable so that I can dynamically change my dimension in the chart based on the selection.

=Pick(Match($(temp_dimension),1,2,3,4, A,B,C,D)) where A,B,C,D are dimensions

When I select a dimension i am not getting the correct order for the chosen dimension. For instance the values in A  are “<35” , “36-70” etc. but the order of display is not coming correctly even after using Sort numerically. Similarly there are other dimensions where similar issue is coming. How can we get sorted results based on our dimension selection 

Please help

Regards

[Qlik1_User1]

@Hercules64 

In "sorting tab" reorder the sorting sequence of these fields and than check.

[sasikanth]

HI, 

You may have to write custom expression for sorting

something like below

if(DIM='A',

wildmatch(only{1}A,'>35','36 to 40','40 to 50'),

If( DIM='B',

wildmatch(only{1}B,'>35','36 to 40','40 to 50'),

If( DIM='C',

wildmatch(only{1}C,'>35','36 to 40','40 to 50'),

If( DIM='D',

wildmatch(only{1}D,'>35','36 to 40','40 to 50')))))

[Hercules64]

Thank you for the prompt response.I tried to give similar expression but it did not work. Please find below the expression that I wrote. 

if (Pick(Match($(temp_dimension),1,2,3,4, A,B,C,D)) =‘A’ , WildMatch(only{1}A, ‘<35’,’36-50’,’51-80’))

kindly let me know if this expression needs to be modified 

Thank you for your time.