topic Rollback 28 first times with expression in QlikView

Rollback 28 first times with expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

How to do a rollback for the first 28 times/days in which Promo ={0} ?

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 )

My problem if the first 28 days Promo <> {0} for example , the resultas will be false ?

Re: Rollback 28 first expression

sunny_talwar — Thu, 03 Mar 2016 11:26:08 GMT

May be this:

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

Re: Rollback 28 first expression

Anonymous — Thu, 03 Mar 2016 11:30:13 GMT

Date(Today() - 30) is the problem , the value 30 should be dynamically changed . In case in rolling back 60 days I will get 28 days in which Promo= {0} so my expression will be

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

Re: Rollback 28 first expression

sunny_talwar — Thu, 03 Mar 2016 11:31:58 GMT

Would you be able to share some sample data to see what you are trying to do? It is rather difficult to understand what you are trying to do, just by looking at your expression.