Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

somme cumulative

Hello,

I would like to perform a cumulative sum on data (sales) ranging from the 1st of january to the selected month. For exemple, for june, I would like to display the sum corresponding to january+february+mars...+june.

What would be the expression formula to use for that?

Thank you in advance.

Sorry, I posted themessage in french first:

Bonjour,

Je voudrais réaliser une somme cumulative sur les ventes depuis le premier janvier jusqu’au mois demandé. Par exemple en juin, j’ai besoin d’afficher le montant  de janvier+février+ mars+avril+mai+juin.

Je vous remercie par avance.

2 Replies
whiteline
Master II
Master II

Hi.

You could try something like this:

Sum({<Month={"=Month<=Max(Month)"}>} sales)

Not applicable
Author

Thank you for your answer