Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
souadouert
Specialist
Specialist

cumulative probleme

I have a problem, I have a table has two column ,

1-DATE:date_s

1-Indicateur :

SUM({<date_s,month={"<=$(=month)"},year={"=$(=MAX(year))"},PRODUIT = {"CREDITS"} , NATURE={"CREDIT A LA CONSOMMATION"}>}PRODUCTTION_VOLUME_TND),


indicateur is the it is the cumulative measure from January to the month displayed in the date column


i used this expression but the result is false, after the analyzes I noticed that the result is date = date and not cumulative

25 Replies
avkeep01
Partner - Specialist
Partner - Specialist

If you add an extra dimension then you should add an aggregation over the rangesum.

AGGR(RANGESUM(ABOVE(SUM({$<month={"<=$(=month)"},year={"=$(=MAX(year))"},PRODUIT = {"CREDITS"} , NATURE={"CREDIT A LA CONSOMMATION"}>}PRODUCTTION_VOLUME_TND),0,ROWNO(TOTAL))),AGENCE)

YoussefBelloum
Champion
Champion

when you select MARS and APRIL, you want this:

01/01/2017 100

01/02/2017, 400

16/03/2017, 800

27/04/2017, 950


??

souadouert
Specialist
Specialist
Author

yes

YoussefBelloum
Champion
Champion

the expression i gave you below give 950 if you select mars and april.

Good luck

souadouert
Specialist
Specialist
Author

IMG_20171127_142658[1].jpg

YoussefBelloum
Champion
Champion

see attached, make the same selections (mars and april)