Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
mwilkinson11
Contributor
Contributor

Heat Map based on previous month value

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: 

mwilkinson11_0-1631809850141.png

I appreciate any help! 

 

3 Replies
chinmayadash07
Contributor II
Contributor II

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?

mwilkinson11
Contributor
Contributor
Author

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! 

chinmayadash07
Contributor II
Contributor II

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