Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I am making a bar chart which deals with the ages of people
the original format is
1 - 2 - 3 - 4 - 5
With which I made a master item Dimension where it changed to
Under 16 - 16 - 17 - 18 - Over 18
When I try to sort the bar chart it changes to
16 - 17 - 18 - Over 18 - Under 16
Is there a way to use an expression to set the order in which it is sorted
I would like it to be sorted as
Under 16 - 16 - 17 - 18 - Over 18
The format is how it is viewed on the X axis of the chart
Any help would be appreciated
Thank you
if(Dual('Under 16',1),if(Dual('16',2),if(Dual('17',3),if(Dual('18',4),5))))
Hi,
If preserved in the data original format is 1 - 2 - 3 - 4 - 5, try sorted on it for dimension Under 16 - 16 - 17 - 18 - Over 18.
Hello
Im using Qlik Sense
Where exactly would that expression be put in
see attached files script and sorting expression in barchart
hope this helps