Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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())