Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Chloe19
Contributor III
Contributor III

Sort by expression, current month only!

I have a pivot table with Region as rows, Months as columns and volumes below it.

I added a measure which shows me if the value is above or below the previous month and now I would like to sort the pivot table by Region where the variance is the largest but ONLY for the current month. 

Variable: vSuarVariance

expression: alt((sum([SUARS]))-after(sum([SUARS])),sum([SUARS]))

Any idea how I could add this under Region, sort by expression but sort only for current month?

Thank you!

Labels (3)
0 Replies