Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
khanashique
Creator II
Creator II

Sort Expression in QlikSense for Graph

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))

 

Capture.JPG

 

Thanks,

MAK.

Labels (4)
1 Solution

Accepted Solutions
khanashique
Creator II
Creator II
Author

Hi,

 

It worked finally, without expression see below snapshot:Capture.JPG

Thanks.

View solution in original post

6 Replies
vishsaggi
Champion III
Champion III

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
Creator II
Creator II
Author

It does not work.

vishsaggi
Champion III
Champion III

Can you share a sample file you are trying this to look into?
khanashique
Creator II
Creator II
Author

I have extracted the data (attached)

khanashique
Creator II
Creator II
Author

other file

khanashique
Creator II
Creator II
Author

Hi,

 

It worked finally, without expression see below snapshot:Capture.JPG

Thanks.