Discussion Board for collaboration on QlikView Scripting.
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.
Please help to resolve or if you have any other solution for doing this please suggest.
Go to Solution.
And make your dtmdate really contains date values and not text strings that only look like dates.
Thanks a ton Gysbert.It's working.
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.
Very useful info. Thanks .
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.