topic Set multiple pre-set Values in formula in QlikView

Set multiple pre-set Values in formula

Anonymous — Thu, 05 Jul 2018 13:01:35 GMT

Hello community,

I want to sum the value of "FA.Abfuellzeit" for the current week in the current year.

the variable: vAktuelleKW = week(date(today()));

I started with the expression: =(sum({$<KW={$(=vAktuelleKW)}>} FA.Abfuellzeit)) which already puts out the value for the current week, but for all years possible.

How can I achieve it, that the year is the current one as well?

Thank you for your help in advance.

Re: Set multiple pre-set Values in formula

Anil_Babu_Samineni — Fri, 06 Jul 2018 03:39:55 GMT

You meant to say this?

vMaxYear = Year(Today());

And Expression is this?

=(sum({$<KW={$(=vAktuelleKW)}, Year={$(=vMaxYear)}>} FA.Abfuellzeit))

Re: Set multiple pre-set Values in formula

Anonymous — Fri, 06 Jul 2018 05:55:19 GMT

Yes, it works!

Thank you, that was exactly what I was looking for, yet so simple!

I apprechiate that.

Thanks