Discussion board where members can get started with Qlik Sense.
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))
Go to Solution.
It worked finally, without expression see below snapshot:
View solution in original post
It does not work.
I have extracted the data (attached)