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: 
gerhardl
Creator II
Creator II

Use value from different dimension in each dimension

Hi, hope I can explain this properly.

See attached image:

1.jpg          

I have the Status and the Date as dimensions. What I need to do (in a separate pivot table) is show the movement between the months for each status, i.e. I need to subtract the 2018/08/31 status count from the 2017/09/30 status count and show it under 2017/09/30, like this:

2.jpg

My first problem is how to do this (referencing the PREVIOUS month under the CURRENT month's dimension), and secondly, this will be updated monthly so I need to be able to automatically retrieve/derive the previous month's date so it can be used as a variable in the set analysis .

1 Solution

Accepted Solutions
sunny_talwar

May be this

Sum(Measure) - Before(Sum(Measure))

View solution in original post

2 Replies
sunny_talwar

May be this

Sum(Measure) - Before(Sum(Measure))

gerhardl
Creator II
Creator II
Author

I sometimes amaze myself with how little I know...

Thought this would be tricky to do. Thanks so much