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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
cicciput
Contributor III
Contributor III

[Set analysis] subtract set using As Of Month rolling periods

Following community advice I implemented an AsOfMonth table in my load: Calculating rolling n-period totals, averages or other aggregations

So I have such data:

Screenshot - 10282014 - 05:55:30 PM.png

and now I can count:

  • how many buyers in current month Sum({<As_Of_Month.Type={'Current'}>} Account.DCF)
  • how many buyers in rolling quarter Sum({<As_Of_Month.Type={'Rolling 3'}>} Account.DCF)
  • how many buyers in previous rolling quarter Sum({<As_Of_Month.Type={'Prev. rolling 3'}>} Account.DCF)

Now my question: how do I count how many buyers purchased in previous rolling quarter but not in the next rolling quarter?

I assumed this but it does not work:


Sum({<As_Of_Month.Type = {'Prev. rolling 3'} - {'Rolling 3'} >} Account.DCF)

as it counts the same as Sum({<As_Of_Month.Type={'Prev. rolling 3'}>} Account.DCF)

Screenshot - 10282014 - 06:05:41 PM.png

Any advice welcome.

1 Reply
cicciput
Contributor III
Contributor III
Author

Is my request something you simply can't get from Qlikview?