Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sort by total?

Hi,

Is there a way to sort by the total?

I have the following table

However, as you can see the Total's column that was created in the Presentation's tab selecting the Show Partial Sums. I have tried with sort by Y value but is changing the sort of the months and it's not sorting by highest total to lowest total. Is there a way to do this?

The expression is count of ids, so it's not possible to do the sum there.

Thanks,

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Sort the first dimension (not month) by expression. Use the same expression formula that you use in your chart expression.


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

Sort the first dimension (not month) by expression. Use the same expression formula that you use in your chart expression.


talk is cheap, supply exceeds demand