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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

help with range and simple tables

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 Solution

Accepted Solutions
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())

View solution in original post

2 Replies
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())

Not applicable
Author

thank u carneyfm that really help me alot, thanks again