Traffic light gauge to show last 12 months indicators

[leowyk1188]

Hello all,

Currently i have 11 months of data with month format as "201901,201902,2019,03..."

How can i setup a variable to bring me the last 12 months figures and have 12 traffic light indicator (based on that month's results) on a straight table?

(PS. i know how to setup the traffic light gauge in a straight table to bring me the current month's traffic light indicator)

[rubenmarin1]

Hi, it will be easier with a master calendar where you can work with expression and these fields that helps to filter data, is example if you want always the last 12 months based on current date (or reload time date) you can just add a flag in master calendar:

If(tmpDate>=AddMonths(Today(),-12), 1, 0) as is12M

If you only have that field maybe using set analysis like:

Only({<PeriodField={">$(=Date(AddMonths(Date#(Max(PeriodField), 'YYYYMM'),-12),'YYYYMM'))"}>} IndicatorValue)

Using PeriodField as dimension it should work.

[Brett_Bleess]

Just adding to the other post, here is a Design Blog post that may be of further help regarding the Master Calendar...

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

Here is the base URL for the Design Blog area too in case you want to do some further searching there:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Hopefully this along with the other post will get you what you need to get things working as you wish.  Shout back if you have further questions, otherwise be sure to use the Accept as Solution button on any post(s) that helped you get things resolved.

Regards,
Brett