help with ranges

Thu, 27 Aug 2009 22:38:00 GMT

hi, im new with QlikView and i'd like to know how is possible to do this:

i have a dim.Document and Fact tables like this:

Document:
LOAD DOCUMENT,
"ID_DOCUMENT",
"ID_COUNTRY",
LIMIT
FROM DimDocument.QVD (qvd);

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

in Document, Limit means each document has lower limit like 5 minutes and in Fact S_Time_AVG there is X minutes for each document, so im trying to get Limit from documents and applied to S_TIme_AVG as a lower range in a simple Graphic table, in the visual effects tab under a expression:

finally i want to paint each row depending if SLA is <= S_Time_AVG

i hope somebody can understand me

Pablo Cifuentes

topic help with ranges in QlikView

help with ranges