topic help with range and simple tables in QlikView

help with range and simple tables

Thu, 27 Aug 2009 22:49:13 GMT

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

Fri, 28 Aug 2009 17:11:27 GMT

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

Fri, 28 Aug 2009 20:25:10 GMT

thank u carneyfm that really help me alot, thanks again