Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikwiz123
Creator III
Creator III

Sort rows by latest month in Descending Order

 

I want to sort my rows based on the latest month values in Descending, not changing the order of the months.

 

Current Sort:

qlikwiz123_0-1683574433991.png

Expected Output:

qlikwiz123_1-1683574570075.png

 

 

Labels (2)
1 Solution

Accepted Solutions
MayilVahanan

Hi

Sort the category Dimension by Expression -> Descending Order
Sum({<[Received Month]={"$(=Max([Received Month]))"}>}%Volume)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

1 Reply
MayilVahanan

Hi

Sort the category Dimension by Expression -> Descending Order
Sum({<[Received Month]={"$(=Max([Received Month]))"}>}%Volume)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.