topic Custom Sort for a bar chart in QlikView

Custom Sort for a bar chart

Anonymous — Wed, 02 Aug 2017 13:47:03 GMT

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

Frank_Hartmann — Wed, 02 Aug 2017 13:51:28 GMT

if(Dual('Under 16',1),if(Dual('16',2),if(Dual('17',3),if(Dual('18',4),5))))

ahaahaaha — Wed, 02 Aug 2017 13:55:12 GMT

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.

Anonymous — Wed, 02 Aug 2017 13:55:32 GMT

Hello

Im using Qlik Sense

Where exactly would that expression be put in

Frank_Hartmann — Wed, 02 Aug 2017 14:19:02 GMT

see attached files script and sorting expression in barchart

hope this helps