Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
sudhir0538
Creator
Creator

Week to Date Calculation using set analysis

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,

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand

View solution in original post

sudhir0538
Creator
Creator
Author

Thanks a ton Gysbert.It's working.

jagan
Luminary Alumni
Luminary Alumni

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.

sudhir0538
Creator
Creator
Author

Hi Jagan,

Very useful info. Thanks .

Not applicable

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.