Discussion Board for collaboration related to Creating Analytics for QlikView.
I have a bar graph with a calculated dimension like this:
= if (budget <= 100, 'bis ' & 100,
if(budget > 100 and budget <= 200, 'bis ' & 200,
'bis' is the german word for 'up to'. The result is a diagram like this:
As you see, the calculated dimension (x-axis) is not in the correct order. Correct would be:
I can not sort by number or by alphabetical order, the results are always wrong. But how can I sort such a dimension with an expression?
Go to Solution.
= if (budget <= 100, dual('bis & 100', 1),
if(budget > 100 and budget <= 200, dual('bis 200',2),
and then sort them by numeric value
View solution in original post
It worked. Thank you very much.
Thank you so much!
Thank a lot Ramon, i was trying for this many times, you saved my time.