Discussion Board for collaboration on QlikView Layout & Visualizations.
Go to Solution.
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.
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?