topic retrieve past 3 weeks and current week from Time Week Year Number column in QlikView

retrieve past 3 weeks and current week from Time Week Year Number column

Anonymous — Thu, 08 Oct 2015 14:26:57 GMT

Hi,

I have a column like [Time Week Year Number] and it is having values like 1 to 53. I want to retrieve past 3 weeks and current week value. Pls help me how to get it.

Regards,

Kumar

Re: retrieve past 3 weeks and current week from Time Week Year Number column

nagaiank — Thu, 08 Oct 2015 14:33:26 GMT

If you have the current week number in a variable ( e.g. vCurrentWeekNumber) from your calendar, you may use the expression

[Time Week Year Number] >= $(vCurrentWeekNumber) and [Time Week Year Number] <= $(vCurrentWeekNumber)

Re: retrieve past 3 weeks and current week from Time Week Year Number column

Anonymous — Fri, 09 Oct 2015 05:38:09 GMT

Hi,

Thanks for ur reply.

I need past 3 weeks. Here we can't get past 3 weeks, I am thinking. Can you correct me, if I am wrong.

I have week numbers from this column [Time Week Year Number]

Re: retrieve past 3 weeks and current week from Time Week Year Number column

SreeniJD — Fri, 09 Oct 2015 05:54:01 GMT

Hi Kumar,

Try this..

Last 3 weeks..

If you have date, use this format..

Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=WeekStart(Max(Date), -2))<=$(=Date(Max(Date)))’}>} Value )

Regards,

Sreeni