topic Re: Qlik Sense sorting descending within 2 dimensions based on values in one column in App Development

Qlik Sense sorting descending within 2 dimensions based on values in one column

SamF — Sat, 16 Nov 2024 20:01:49 GMT

I am looking for a simple way to sort descending within 2 dimensions based on the values of one column (latest month of data) in a Qlik Sense pivot table.

I can not provide actual data or my Qlik Sense file but a a rough example of the data is below where the descending sort would show REGION A first at it totals to 12 in Feb (latest month) which is higer than REGION B's 10. Then within REGION A, CITY1 is first since it is has the highest value in Feb and within REGION B, CITY3 first since it has the highest value in Feb :

COLUMNS Jan Feb
-REGION A 6 12
--CITY1 2 10
--CITY2 4 2
-REGION B 8 10
--CITY3 2 6
--CITY4 6 4

I have tried putting the below expression in a sort by expression descending for both dimensions: <sum( if ( MONTH='Feb' , Value-Feb, ) )>. This and various combinations thereof have not worked.

Re: Qlik Sense sorting descending within 2 dimensions based on values in one column

Saranyat — Tue, 24 Sep 2019 13:24:52 GMT

canu share sample data please

Re: Qlik Sense sorting descending within 2 dimensions based on values in one column

SamF — Tue, 24 Sep 2019 15:03:44 GMT

What I can provide is in the initial post. Does that make sense?

Re: Qlik Sense sorting descending within 2 dimensions based on values in one column

SamF — Fri, 27 Sep 2019 01:07:09 GMT

Can anybody help with this issue please