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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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?