Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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