Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
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!