Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
SamuelHaag
New Contributor II

Sorting by a measure that is not used in the visualization

Hi guys,

is it possible to sort by a measure that is not used in the visualization?

For example: I have a bar chart that shows the "Sales" of 10 Cusomters. I want to sort these 10 customers by the field "Contribution margin". So what I want are the sales of the 10 Customers with the highest "Contribution margin".

 

What I tried is something like this to sort it but it didn't work:

if(max([Contribution margin]),   dual([Customer], 1),

if(max([Contribution margin],2), dual([Customer], 2),

if(max([Contribution margin],3), dual([Customer], 3),

if(max([Contribution margin],4), dual([Customer], 4),

if(max([Contribution margin],5), dual([Customer], 5),

if(max([Contribution margin],6), dual([Customer], 6),

if(max([Contribution margin],7), dual([Customer], 7),

if(max([Contribution margin],8), dual([Customer], 8),

if(max([Contribution margin],9), dual([Customer], 9),

if(max([Contribution margin],10), dual([Customer], 10)

))))))))))

 

Thank you ver much!

 

Samuel

1 Solution

Accepted Solutions
Partner
Partner

Re: Sorting by a measure that is not used in the visualization

Yes. go to sorting section as add the expression needed.

e.g. i have a table woth Month year  as dimension and Sales as measure but i want sort by number of order. i create a regular table. order it by Monthyear. then go to sorting section and change as below picture

Capture.PNG

Result

MonthYearSales
May-1998$18,333.63
Jun-1997$36,362.80
Mar-1997$38,547.22
Jul-1997$51,020.86
Jan-1997$54,326.47
Feb-1997$38,483.63
Apr-1997$53,032.95
Aug-1997$47,287.67
Nov-1997$43,533.81
Sep-1997$55,629.24
May-1997$53,781.29
Oct-1997$66,749.23
Dec-1997$71,398.43
Feb-1998$99,415.29
Jan-1998$94,222.11
Mar-1998$104,854.15
Apr-1998$123,798.68

View solution in original post

2 Replies
Partner
Partner

Re: Sorting by a measure that is not used in the visualization

Yes. go to sorting section as add the expression needed.

e.g. i have a table woth Month year  as dimension and Sales as measure but i want sort by number of order. i create a regular table. order it by Monthyear. then go to sorting section and change as below picture

Capture.PNG

Result

MonthYearSales
May-1998$18,333.63
Jun-1997$36,362.80
Mar-1997$38,547.22
Jul-1997$51,020.86
Jan-1997$54,326.47
Feb-1997$38,483.63
Apr-1997$53,032.95
Aug-1997$47,287.67
Nov-1997$43,533.81
Sep-1997$55,629.24
May-1997$53,781.29
Oct-1997$66,749.23
Dec-1997$71,398.43
Feb-1998$99,415.29
Jan-1998$94,222.11
Mar-1998$104,854.15
Apr-1998$123,798.68

View solution in original post

SamuelHaag
New Contributor II

Re: Sorting by a measure that is not used in the visualization

Thank you very much! I got it!