Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

help with range

hey i have a problem

im using a simple graphic table and i want to paint each row depending a validation, im using this tables

FACT:
LOAD "ID_DOCUMENT",
"ID_PROCESS",
"ID_PRODUCT",
"S_TIME_AVG"
FROM FACTS_Docs.QVD (qvd);

Document:
LOAD DOCUMENT,
"ID_DOCUMENT",
"ID_PAIS",
SLA
FROM DimDocument.QVD (qvd);

and i need to compared if SLA is <= AVG(S_TIME_AVG) then paint red else paint red each row

i don know witch control or what i have to do to get this

thanks

Pablo Cifuentes

1 Reply
Not applicable
Author

Go to the Dimension or Expression Tab (depending on what aspects to the row you want to highlight)

Expand the + sign, select Backgound Color and select Edit

in the expression type


=if(SLA<= AVG(S_TIME_AVG), DarkGray(), Blue())