Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
jajati_k_dev
New Contributor II

QlikView Heat Map

Hi,

I have created a pivot table which has the following columns;

  1. Product Line
  2. OTS Target
  3. Data Column's by Month

Each Product Line row has a target for measuring performance, which is the guiding factor for color coding for that specific row.

Example;

For Product Line - 6A, OTS Target is 9 days.

Now in that row cell data which is above 9 days need to be colored in 'Red' and cell data less than equal to 9 days need to be colored 'Green', while row cells which have no data should remain as is.

ScreenHunter_04 Mar. 09 17.38.jpg

Regards,

Dev

Tags (1)
2 Replies
Highlighted
Partner
Partner

Re: QlikView Heat Map

Hi,

For each expression or dimension, you can just expand it and write an if statement for the background colour

Highlighted
vikasmahajan
Esteemed Contributor

Re: QlikView Heat Map

go through this thread

Vikas