topic Re: Qlik Sense rolling months with YearMonth selection in App Development

Qlik Sense rolling months with YearMonth selection

kruel830 — Fri, 24 Aug 2018 06:13:10 GMT

Hello,

I have troubles to implement 12 months rolling sum graphs in Qlik Sense. I have created the as-of table as described in this link: https://community.qlik.com/blogs/qlikviewdesignblog/2015/11/02/the-as-of-table . Rolling period calculation is also as in that guide: dimension: AsOfMonth, measure: Sum({$<MonthDiff={"<12"}>} Sales).

I get desired graph by selecting 12 months from AsOfMonth filter pane:

The problem is, the whole app is designed to be used by selecting single month from the YearMonth-filter. When I make that selection, the graph looks like this:

Without any filters, the visual looks like this:

I would be grateful for any help. Thank you.

Re: Qlik Sense rolling months with YearMonth selection

BalaBhaskar_Qlik — Sat, 25 Aug 2018 15:18:08 GMT

May be use these expressions:

Set Analysis for Rolling Periods

Re: Qlik Sense rolling months with YearMonth selection

BalaBhaskar_Qlik — Sat, 25 Aug 2018 15:19:00 GMT

Try your expression like this:

num(Avg({<Month_Year>}Aggr(((Sum({<Month_Year = {"=Date#(Only({1} Month_Year), 'MMM-YYYY') >= AddMonths(Max(TOTAL Date#(Month_Year, 'MMM-YYYY')), -12) and Date#(Only({1} Month_Year), 'MMM-YYYY') <= Max(TOTAL Date#(Month_Year, 'MMM-YYYY'))"}>}a/b))*Only({<Month_Year>} c)), empid, Month_Year)

),'#.##')

Re: Qlik Sense rolling months with YearMonth selection

kruel830 — Mon, 27 Aug 2018 06:33:11 GMT

Thank you for your response.

Can't get it work though. What are 'a/b' and 'c' in your example? And also 'empid' seems to be unrecognized function.