COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: ashusharma221084 on 08 Apr 2017 09:20:29 AM

Title: Filter a list from HeatMap Chart
Post by: ashusharma221084 on 08 Apr 2017 09:20:29 AM
Hello,

I've seen some threads where Heatmap chart data is filtered using slidebar or list. But I have just opposite requirement.. Here we want to filter list data using Heatmap chart cell. I have Employee 'overall performance rating' on X axis and their 'potential rating' on Y axis and 'Employee count' is the value to be shown in the heatmap chart cells. This is achieved... But I've a list report which have all employee details. Now the requirement is when I click on any column in the heatmap, it will filter this list and show the details only for those employees who are lying in that category.

Any help is appreciated...

Regards,
Ashish
Title: Re: Filter a list from HeatMap Chart
Post by: MFGF on 10 Apr 2017 03:40:53 AM
Quote from: ashusharma221084 on 08 Apr 2017 09:20:29 AM
Hello,

I've seen some threads where Heatmap chart data is filtered using slidebar or list. But I have just opposite requirement.. Here we want to filter list data using Heatmap chart cell. I have Employee 'overall performance rating' on X axis and their 'potential rating' on Y axis and 'Employee count' is the value to be shown in the heatmap chart cells. This is achieved... But I've a list report which have all employee details. Now the requirement is when I click on any column in the heatmap, it will filter this list and show the details only for those employees who are lying in that category.

Any help is appreciated...

Regards,
Ashish

Hi,

The approach is exactly the same - the heatmap visualization is used to set the variables which filter the list.

An example based on GO Sales (query) is attached.

Cheers!

MF.