topic Re: Rolling 6 months in Qliksense in App Development

Rolling 6 months in Qliksense

Aspiring_Developer — Thu, 26 May 2022 15:45:58 GMT

Hello,

I need to show rolling 6 months data in my pivot table and I have written below expression :-

=count({<test={'>=$(=MonthStart(addmonths(Max(test),-6)))<=$(=Max(test))'}>} ISSUE_NO)

But it is giving me blank data. I checked my monthstart and max date expression in KPI's and I am getting range of date .

I have data starting from 1/11/2021 till today (26/05/2022) .

I need to show rolling months for 6 months and I also need to show the weekly data for the above dates.

Not sure , what mistake I am making. Can anyone please help ?

Thanks in advance

saranyadurai — Fri, 27 May 2022 06:39:55 GMT

Can you try this,

Count({<test={">=$(=Date(MonthStart(Max(test), -5),'MM/DD/YYYY'))<=$(=Date(Max(test),'MM/DD/YYYY'))"}>} ISSUE_NO)

Please ensure the date format same as test date.

Thanks,

Aspiring_Developer — Fri, 27 May 2022 08:50:18 GMT

How can I showcase data for weeks ?

Date range 1/11/2021 till today's date

saranyadurai — Fri, 27 May 2022 10:25:39 GMT

Maybe try this,

WTD,

Count({<test={">=$(=Date(WeekStart(Max(test)),'MM/DD/YYYY'))<=$(=Date(Max(test),'MM/DD/YYYY'))"}>} ISSUE_NO)