topic Re: Current Week to the Week 2 Years Ago in QlikView

Current Week to the Week 2 Years Ago

psk180590 — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I have generated the WeekName for each Week in my script and have the Sales values mapped against each week.

Now, in my App i would like to have a chart using Set Analysis and display the results from exactly last 2 years.

Say, the current week is 2018_41. I want the chart to start from 2016_41 to 2018_41 and upon the start of next week 2016_42 to 2018_42.

Thanks

Sai.

psk180590 — Tue, 09 Oct 2018 13:11:56 GMT

Does anyone has any quick suggestion here. A bit urgent!!

Thanks.

dplr-rn — Tue, 09 Oct 2018 14:16:55 GMT

2 options

1) use something like below define variables vMaxDate 2018_41 and vMaxDate_Minus2Yrs as 2016_41

Sum( {<OrderDate={"<=$(=vMaxDate) >=$(=vMaxDate_Minus2Yrs)"}>} OrderRecordCounter)

2) in load script create a flag which is mark last 2 years dates based on max date. use that in set analysis. Prefer this one my self