Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Highlight values in PivotTable / Resaltar valores en Tabla Pivotante

Hi good day.

Some of you can help me with the following:

I have a pivot table in which I need to display three data (Client, subclient and ticket number (OT)), in the measurements (columns) I have the amount of tickets (OT's) and the maximum number of days that these tickets have. I need to highlight in red those ticket's that exceed 10 days, for which I use the following function in expression of text color:

if(["Duracion OT (Dias)"]>10,lightred(),black())

However, they are only highlighting those whose quantity column (Cant.) is 1, the other values that are greater than 1 are not highlighted, only when deploying them, as shown in the image:

Tabla pivotante.png

Can any one help me to highlight all please? How can i achieve it?

Muchas gracias

0 Replies