Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What are good expressions to use for applying Date Parameters?

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

*YTD

Help would be greatly appreciated.

1 Reply
whiteline
Master II
Master II

Hi.

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