Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

May be this

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

View solution in original post

2 Replies
Highlighted

May be this

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

View solution in original post

Highlighted
Creator II
Creator II

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

Thought this would be tricky to do. Thanks so much