topic Re: Show Data for last 52 weeks from current date Qliksense in App Development

Show Data for last 52 weeks from current date Qliksense

Aspiring_Developer — Fri, 20 Jan 2023 09:29:28 GMT

Hello All ,

I have below data set :-

Dimension -'Week' & chr(10) & Week(Date)

Dimension -=If(WildMatch(Date, '*' & Year(Today())), DATE_MON)

Dimension - LOB

Measure - sum({<Monday_flag={1}, Year_trend={'$(=Max(Year_trend))'}>}TREND_VOL)

My requirement is to show data for last 52 weeks starting from current date but as the new year started it is only showing the data for a single month of Jan 2023.

And we have created below flags to show the opening number of every week i.e Monday :-

If(WeekDay(REPORT_DATE)='Mon' or Day(REPORT_DATE)=1, REPORT_DATE) as REPORT_DATE_MON

if(weekday(REPORT_DATE)='Mon' or Day(REPORT_DATE)=1, 1,0) as Monday_flag,

How Can I show the data for last 52 weeks considering the current month and year as well so that next time when the year changes it should not hamper the results?

Thanks in advance

Re: Show Data for last 52 weeks from current date Qliksense

Aspiring_Developer — Fri, 20 Jan 2023 12:15:36 GMT

Hello,
Can anyone please help me on this one ?

Thanks

Re: Show Data for last 52 weeks from current date Qliksense

Aspiring_Developer — Mon, 23 Jan 2023 08:01:22 GMT

Hi ,

Can anyone please help me on this one ?

Thanks

Re: Show Data for last 52 weeks from current date Qliksense

vinieme12 — Wed, 25 Jan 2023 06:54:14 GMT

use the date field in your calculations as below to restrict the calculation period

Last 52 Weeks

=Sum({<REPORT_DATE={">=$(=WeekStart(Max(REPORT_DATE),-52))<=$(=Max(REPORT_DATE))"}>}SomeMeasure)