Discussion Board for collaboration related to QlikView App Development.
You try using the dual function to sort you values.
IF(A >=1 and A<1.25,Dual('iinteresting',1),
if(A>=1.25 and A<2.25,Dual('empty',2),
if(A>=2.25 and A<3.25,Dual('grandfather',3),
if(A>=3.25 and A<=4,Dual('nearly',4)))))
Sort this dimension by numeric. Best way to do this is, create this as a column in back script and use the field in front end as show in this attached post.
Hope this helps you.
View solution in original post
Have you considered using Dual() function? Something like this...
IF(A >=1 and A<1.25, Dual('iinteresting', 1),
if(A>=1.25 and A<2.25, Dual('empty', 2),
if(A>=2.25 and A<3.25, Dual('grandfather', 3),
if(A>=3.25 and A<=4,Dual('nearly', 4)))))
Cheers - DV
Thanks a lot!
But what if the legend doesn't represent each separate member in a dimension;
But a separate expression; i.e. sum of income, sum of bonus ;
What determines the order then?