topic Re: Calculate sum before a specific date in QlikView

Calculate sum before a specific date

mrbqlik2009 — Sat, 16 Nov 2024 00:37:20 GMT

hi,

suppose i have this table in database.

i want calculate sum(amount) of records with name 'x' and before date for example 01/22/2020 in expression in a chart.

for example the answer become 20+27=47

show 47.

Taoufiq_Zarra — Fri, 22 May 2020 15:10:55 GMT

Maye be :

=sum({$<Name={'x'},Date={"<=$(=Date#('1/22/2020','M/DD/YYYY'))"}>} amount)

mrbqlik2009 — Fri, 22 May 2020 15:19:05 GMT

thank you for reply.

I put specific date in a variable.

suppose Date and specific date is not in format 'MM/DD/YYYY'.

how can i calculate both in this format.

Taoufiq_Zarra — Fri, 22 May 2020 15:26:12 GMT

you can change Date Format in 'MM/DD/YYYY' to another

bellow with variable :

=sum({$<Name={'x'},Date={"<=$(=vDate)"}>} amount)

mrbqlik2009 — Fri, 22 May 2020 15:35:46 GMT

can put Date#('01/01/2020','YYYY/MM/DD') in expression?

Taoufiq_Zarra — Fri, 22 May 2020 15:40:54 GMT

no but

=Date#('2020/01/01','YYYY/MM/DD')