Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Pivot table background color

Hi, I read several disscusion about this topic but still haven´t found an answer.

I created a pivot table and I´m trying to colour its data according to its values, but still havent found how to color columns AND rows and that the colour has meaning with the data.

For example:

In this example number 44 has different colours deppending on the row, but I need it to have the same colour if its the same number not deppendig on the row.

Captura.JPG.jpg

I´m attaching the qvw of this example, hope someone out here can help me,  thanks!!

Tags (2)
3 Replies
Highlighted
Contributor III
Contributor III

Re: Pivot table background color

I know this kind of color filter is very easy to create on excel using conditional formatting.

Highlighted
Partner
Partner

Re: Pivot table background color

so it is in QV , but your expression makes it look wrong.

If the requirement is 44 to have the same color then use an if statement but without colormix.

or if you want a range of numbers to have the same color, use the visual cues tab

Highlighted
Contributor III
Contributor III

Re: Pivot table background color

Hi, is there a posibility to have an example ussing the if statement on the qvw I upploaded?

Thanks!