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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
ALLALOU
Contributor
Contributor

Calulate a mesure based on year N-1

 

Hello ,

I want to calculate a sum of mesure based on data from the previous Year (N-1)

expression to calculate my mesure on Year N :

 If(PERIODE='MTD',Sum({<[Date_Commande.autoCalendar.Date]={"$(=Max(Date_Commande.autoCalendar.Date))"}>}[Actuals MTD Année N]),
Sum({<[Date_Commande.autoCalendar.Date]={"$(=Max(Date_Commande.autoCalendar.Date))"}>}[Actuals YTD Année N])
)

I have 2 fields : 

[Mois/Année] : give me Month+year  (example 03/2020)

[Mois/Année Daily-1] : give me Month+year  N-1 (example 03/2029)

Thanks 

0 Replies