Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
and now I can count:
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)
Any advice welcome.
Is my request something you simply can't get from Qlikview?