Sum for the Current Week

ksomosera10 — Thu, 07 Sep 2017 05:39:49 GMT

Hi,

I have this Expression:

=SUM([Local])

But the problem is that it sums all of my "Local" values for the whole year up to today. I have a column containing week number, so everytime I need to see the values of Local for the current week, I add a filter for weeks which makes the report not user-friendly. Can you help me out?

I want to automatically get the sum of Local but, just for the current week.

I have 3 columns that can be use.

Primary Index, Local(int), WeekNumber(int)

Is this possible?

Thanks!

Re: Sum for the Current Week

sumeet-vaidya — Thu, 07 Sep 2017 05:54:21 GMT

Hi Kevin,

Kindly use below Expression in your Set Analysis to get Local value for the Current Week.

Sum({<Weeknumber = {"$(=Week(Today()))"}>}Local)

Regards

Sumeet Vaidya

topic Sum for the Current Week in QlikView

Sum for the Current Week

Re: Sum for the Current Week