topic Re: sum last date in selected weeks in QlikView

sum last date in selected months

davinfrost — Wed, 25 Nov 2020 16:16:04 GMT

hi guys,

i want to ask , how to sum a specific date on every month ,

in this case i want sum every last date on every month,

for example, if i filtered january,february and march, that means it will sum on 01/31 , 02/28, 03/31.

for now i only use this condition

sum(
{<
FLAG_TRANS={'Outstanding'},
Year={'$(=max(Year))'}
>}
OOWING)

any help?

thanks

namratam3 — Thu, 15 Nov 2018 10:05:22 GMT

=if(getselectedcount(month)>0,sum({<year={"$(=max(year))"},date={"$(=monthend(date))"}>}OOWING),sum({<year={"$(=max(year))"}>}OOWING))

andrey_krylov — Thu, 15 Nov 2018 10:47:09 GMT

sum(

{<
Date={"=If(Date=Text(Date(MonthEnd(Date))), Date)"},
Year={'$(=max(Year))'}
>}
OOWING)

davinfrost — Mon, 19 Nov 2018 03:02:29 GMT

cool, thanks mate