Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
mwilkinson11
Contributor
Contributor
‎2021-09-16 12:33 PM

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! 

 

430 Views
0 Likes
3 Replies
chinmayadash07
Contributor II
Contributor II
‎2021-09-16 01:06 PM

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?

420 Views
0 Likes
mwilkinson11
Contributor
Contributor
‎2021-09-16 02:42 PM
Author

In response to chinmayadash07

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! 

395 Views
0 Likes
chinmayadash07
Contributor II
Contributor II
‎2021-09-16 02:52 PM

In response to mwilkinson11
  • U can use before function to acieve the same .it will compare the current column value vs previous month value in the pivot table
391 Views
0 Likes