Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Karahs
Partner - Creator
Partner - Creator

Measure Cal

Hello everyone,

I took Row dimension as Month and Column dimension as Names and Measure as Sum(Amount)-Above(Sum(Amount)) and got  Monthly Variance.What measure should i use if i take Month as column and names as Rows ?

question.png

Thanks!

1 Solution

Accepted Solutions
Gysbert_Wassenaar

sum(Amount) - Before(sum(Amount))


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

sum(Amount) - Before(sum(Amount))


talk is cheap, supply exceeds demand
Karahs
Partner - Creator
Partner - Creator
Author

Thanks lot,it worked .