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
