topic Re: Heat Map based on previous month value in App Development

Heat Map based on previous month value

mwilkinson11 — Thu, 16 Sep 2021 16:33:54 GMT

Hi Everyone!

Is there a way in Qlik Sense to create a heatmap within a pivot table based on a previous months value? See example below:

I appreciate any help!

Re: Heat Map based on previous month value

chinmayadash07 — Thu, 16 Sep 2021 17:06:11 GMT

Ok, we can do using a variable to achieve the same, meanwhile, could u please help me understand on one query, are u showing previous month in this pivot table?

Re: Heat Map based on previous month value

mwilkinson11 — Thu, 16 Sep 2021 18:42:23 GMT

No, I am sorry. The example shows previous FY Quarter. I would like to be able to do either previous FY quarter or month.

Thanks!

Re: Heat Map based on previous month value

chinmayadash07 — Thu, 16 Sep 2021 18:52:07 GMT

U can use before function to acieve the same .it will compare the current column value vs previous month value in the pivot table