Discussion Board for collaboration related to QlikView App Development.
I am looking to calculate how units have been sold in the follow based on calculating against today's date:
*Last 30 days
*Last 60 days
*Last 12 months
Help would be greatly appreciated.
To calculate separate values set analysis + data flags approach is usually preferable.
To calculate cumulative and rolling sums in time you could use asoftable approach.
Calendar with flags making set analysis so very simple
Calculating rolling n-period totals, averages or other aggregations