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
YoussefBelloum
Champion
Champion

Hi,

you should use syntax like this:

=sum( {<date_s={">=01/01/2017  <=$(=max(date_s))"}>} PRODUCTTION_VOLUME_TND)

souadouert
Specialist
Specialist
Author

Hello youssef ,
I tested this expression but nothings changed because i have the date_s in the colunm So , the indicateur folow this date

YoussefBelloum
Champion
Champion

try just to test it (add it on a textbox for example)

if yo have data like this for examples:

Date, Mois, Indicateur

01/01/2017, 01, 100

01/02/2017, 02, 300

16/03/2017, 03, 400

27/04/2017, 04, 150


if you select 16/03/2017 on the date listbox, you will have Sum = 800

if you select 01/02/2017 on the date listbox, you will have Sum = 400

avkeep01
Partner - Specialist
Partner - Specialist

Hi Souad,

You could try:

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



souadouert
Specialist
Specialist
Author

my date FORMAT is MM/YYYY,

souadouert
Specialist
Specialist
Author

it can causes problems

souadouert
Specialist
Specialist
Author

hello, van keep

this expression doesnt satisfaited my needs

YoussefBelloum
Champion
Champion

no problem:


=sum( {<Date={">=01/2017  <=$(=max(Date))"}>} Indicateur)

souadouert
Specialist
Specialist
Author

Yes, i aleardy tested but no thing changed the problem is with th column date_s when i deleted , the indicator is true