Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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.

Tags (1)
1 Reply
Highlighted
Master II
Master II

Re: What are good expressions to use for applying Date Parameters?

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