Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
khanashique
Contributor II

Sort Expression in Qlik Sense 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.

1 Solution

Accepted Solutions
khanashique
Contributor II

Re: Sort Expression in Qlik Sense for Graph

Thanks,

See the snapshot below after changing the category to custom and sorting is as Alphabetical Order descending...it worked.

Capture.JPG

Thanks for your reply.

 

3 Replies
MVP
MVP

Re: Sort Expression in Qlik Sense for Graph

Valuelist is not bound to the data in any way, so I don't its a good candidate for controlling the sorting. It looks like you also have a sort by value set on this object. Remove that and sort by text instead.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
bhargav_bhat
Contributor II

Re: Sort Expression in Qlik Sense for Graph

Check if the sorting is at the top 
text.PNG

khanashique
Contributor II

Re: Sort Expression in Qlik Sense for Graph

Thanks,

See the snapshot below after changing the category to custom and sorting is as Alphabetical Order descending...it worked.

Capture.JPG

Thanks for your reply.