Sort Expression in QlikSense for Graph

[khanashique]

Hi Experts,

Below is the Bar graph where i want to sort the graph as per category, first target and then Sales...if you can see below it is jumping when sales is higher than the target. i have tried the below expression but does not work...

if(ValueList('Target','Sales') = 'Target', 1,
if(ValueList('Target','Sales') = 'Sales', 2))

Thanks,

MAK.

[vishsaggi]

Not sure if this works may be try like below in your sort tab of your chart properties for sales

in the sort tab check mark on expression then use below
=if(ValueList('Target','Sales') = 'Target', 1,2)
then sort order as ascending.

[khanashique]

It does not work.

[vishsaggi]

Can you share a sample file you are trying this to look into?

[khanashique]

I have extracted the data (attached)

[khanashique]

other file

[khanashique · Accepted solution]

Hi,

It worked finally, without expression see below snapshot:

Thanks.