topic Re: Latest 5 weeks selection in QlikView

Latest 5 weeks selection

raju_salmon — Mon, 11 Jan 2016 07:05:29 GMT

Hi,

I am using Calendar from my DB, not generating from QV.

Please find the attached sample QVW, here i have created a button to select latest 5 week selection. However i cannot able to write current string. Which field i need to use for this?

Can anyone help me on this?

Re: Latest 5 weeks selection

tresB — Mon, 11 Jan 2016 07:17:35 GMT

PFA

Re: Latest 5 weeks selection

raju_salmon — Mon, 11 Jan 2016 07:26:18 GMT

Thank you Tresco.

Based on your string, it is selecting 03 DEC 2015 to 31 DEC 2015 (Latest 5 weeks in 2015).

Can i get latest 5 from max date?

19 DEC 2015 to 09 Jan 2016.

Thanks

Re: Latest 5 weeks selection

tamilarasu — Mon, 11 Jan 2016 07:36:25 GMT

Check the below attachment. But the date range which you want must be last 3 weeks.

Re: Latest 5 weeks selection

tresB — Mon, 11 Jan 2016 07:36:39 GMT

Can you explain the logic how you get 19 DEC 2015 to 09 Jan 2016 ?

Re: Latest 5 weeks selection

raju_salmon — Mon, 11 Jan 2016 07:46:15 GMT

Hi,

I have data till yesterday in my app, so i need to see latest weeks. Thank you Tresesco.

Re: Latest 5 weeks selection

tamilarasu — Mon, 11 Jan 2016 07:54:01 GMT

I just used below expression.

='<=' & Date(WeekStart(Today())-2) & '>=' & Date((WeekStart(Today())-2)-21)

If you got the solution, please close the thread.

Re: Latest 5 weeks selection

raju_salmon — Mon, 11 Jan 2016 08:02:36 GMT

Hi Nagaraj,

Can we use this on Max(DATE) field instead of today?

Because i may have data till last month, then i need to get from that MAX(DATE) to latest 5 weeks.

In my App, i have dates till dec 2016, however when i left join this to my main table, the latest date is Jan5th2016.

Sorry for not providing this info in mail question. Thanks.

I have tried with below for last 13 weeks,

='<=' & Date(WeekEnd(MAX(DATE))-1) & '>=' & Date(WeekEnd(MAX(DATE))-78)

and it is working.

My question is, as we are calculating number 78 or 21, will it get create any problem if max(Date) changes?

Can we apply the logic on CAL_WEEK_NUM field, so that there will be no problem in future?

Re: Latest 5 weeks selection

tamilarasu — Mon, 11 Jan 2016 08:08:02 GMT

Can you post your exact output against your attachment.? It would be helpful for me to provide the solution easily.

Re: Latest 5 weeks selection

tamilarasu — Mon, 11 Jan 2016 08:18:55 GMT

Well. I really don't understand your logic. Can you explain me the logic with some example.?

Re: Latest 5 weeks selection

raju_salmon — Mon, 11 Jan 2016 08:22:32 GMT

Sorry for the confusion.

Please find the attached QVW and my string to select last 13 weeks based on MAX(DATE).

It is working, however i have question if MAX(DATE) changes, will it work if i use (no.of days if i deduct? -78 days?

Because i need to calculate for last 13months as well.

Re: Latest 5 weeks selection

tresB — Mon, 11 Jan 2016 08:30:41 GMT

You could rather use Week Shift paramter like:

='<=' & Date(WeekEnd(MAX(DATE))-1) & '>=' & WeekEnd(MAX(DATE),-13)

Re: Latest 5 weeks selection

tamilarasu — Mon, 11 Jan 2016 08:50:52 GMT

Hi Raju Salmon,

I guess the above expression works. You can check by modifying date in your initial load.

Weekend will return the last Sunday date. So I just use -1 as week offset to find the last Saturday.