topic Re: Week to Date Calculation using set analysis in QlikView

Week to Date Calculation using set analysis

sudhir0538 — Mon, 18 Jan 2016 14:25:46 GMT

Hi all

As per my knowledge i wrote this statement but it's not working fine as I expected.

I want to find the sum of the value where the date is between starting and end of the weeks date.

=Sum({<dtmdate={>=WeekStart(Today()) <=WeekEnd(Today())}>}Value)

Please help to resolve or if you have any other solution for doing this please suggest.

Sudhir,

Re: Week to Date Calculation using set analysis

Gysbert_Wassenaar — Mon, 18 Jan 2016 17:57:44 GMT

Try this:

=Sum({<dtmdate={">=$(=WeekStart(Today()))<=$(=WeekEnd(Today()))"}>}Value)

And make your dtmdate really contains date values and not text strings that only look like dates.

Re: Week to Date Calculation using set analysis

sudhir0538 — Tue, 19 Jan 2016 02:04:32 GMT

Thanks a ton Gysbert.It's working.

Re: Week to Date Calculation using set analysis

jagan — Tue, 19 Jan 2016 02:06:27 GMT

Hi Sudhir,

Check this link for more expressions similar to this

Set Analysis for certain Point in Time

Set Analysis for Rolling Periods

Hope this helps you.

Regards,

Jagan.

Re: Week to Date Calculation using set analysis

sudhir0538 — Tue, 19 Jan 2016 02:09:03 GMT

Hi Jagan,

Very useful info. Thanks .

Re: Week to Date Calculation using set analysis

Wed, 03 Feb 2016 12:20:13 GMT

Hi Gysbert,

I need help here, I am trying to achieve count for last week's based on weekstart and weekend and my week starting from Friday and week ending on Thursday.

As per the screenshot I would like to get the sales from Friday to Thursday.

Please look into it.