topic Re: Sum last year until current calendarweek in QlikView

Sum last year until current calendarweek

Fri, 17 Oct 2014 12:28:16 GMT

Hi experts

I would like to compare the following values in a table:

These are my formulas:

1. Sum of my sales of the current year:

Sum ({<Year={$(VmaxYear)}>} ([Sales]))

1. Sum of my sales of the last year:

Sum ({<Year={$(VPrevYear)}>} ([Sales]))

BUT for last year only until the current week.

How would I have to script this? I was thinking about defining a variable that is then inserted into the "Sum ({<Year={$(VPrevYear)}>} ([Sales]))" command.

Thank you for your help!

Jan

Re: Sum last year until current Kalenderweek

Gysbert_Wassenaar — Fri, 17 Oct 2014 13:24:06 GMT

Perhaps this: Sum ({<Jahr={$(VVorjahr)}, Woche={'<=$(=max({<Jahr={$(VmaxJahr)}>}Woche)'}))>} ([Sales]))

Re: Sum last year until current calendarweek

Fri, 17 Oct 2014 13:56:22 GMT

Hi Gysbert

Thank you. Looks good. But does not work yet...

Best

Jan