Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
khanashique
Contributor 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.

1 Solution

Accepted Solutions
khanashique
Contributor II

Re: Sort Expression in QlikSense for Graph

Hi,

 

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

Thanks.

6 Replies
vishsaggi
Esteemed Contributor III

Re: Sort Expression in QlikSense for Graph

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
Contributor II

Re: Sort Expression in QlikSense for Graph

It does not work.

vishsaggi
Esteemed Contributor III

Re: Sort Expression in QlikSense for Graph

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

Re: Sort Expression in QlikSense for Graph

I have extracted the data (attached)

khanashique
Contributor II

Re: Sort Expression in QlikSense for Graph

other file

khanashique
Contributor II

Re: Sort Expression in QlikSense for Graph

Hi,

 

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

Thanks.