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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Rollback 28 days expression

I use the following expression to calculate an average rolling back 28 days

((Sum({<Promo ={0},DateTest={">=$(=Date(Today() - 30)) <$(=Date(Today()-2))"}>} [Prix de vente TTC]))/28 )

how to make a rollback in case Promo ={0} for 28 days ? How to make a rolback for the 28 fisrt days back where Promo ={0} ?

1 Reply
Chanty4u
MVP
MVP

=if(agg(Sum({<Promo ={0},DateTest={">=$(=Date(Today() - 30)) <$(=Date(Today()-2))"}>} [Prix de vente TTC]))/28 ))