Set Analysis/IF/RAG assistance required

Tue, 18 Nov 2014 09:29:08 GMT

Hey guys,

I am trying to create RAG rating with the below. It works when a field is selected but when nothing is selected it should turn grey. Instead it turns black! (Error in expression) can somebody help me fix this?

Im using Set analysis with a few variables, and cant seem to locate where the error is.

The formula i am using is below:

(
sum({<YM = {$(vYM)},R = ,P ={'$(vCP)'}>}ACR.#NUMBER_OF_ROWS) = 0
or
sum({<YM = {$(vYM)},R = ,P ={'$(vCP)'}>}ACR.#NUMBER_OF_ROWS) = 0

, RGB(vBLUE1,vBLUE2,vBLUE3),

if(

(round((100*sum({<YM={$(vYM)},P={'$(vCP)'}>}ACR.HOURS)

/

(sum({<YM={$(vYM)},P={'$(vCP)'}>}AC.FE)*$(='vHours'&'$(vPercentageChange)') ))/$(='vPercentage'&'$(vPercentageChange)')

,1))

>=$(='vThresACP_'& vPercentageChange &'_C07High')

,RGB(vRED1,vRED2,vRED3),

if(

(round((100*sum({<YM={$(vYM)},P = {'$(vCP)'}>}ACR.HOURS)

/

(sum({<YM={$(vYM)},P ={'$(vCP)'}>}AC.FE)*$(='vHours'&'$(vPercentageChange)') ))/$(='vPercentage'&'$(vPercentageChange)')

,1))

<=$(='vThresACP_'& vPercentageChange &'_C07Low')

,RGB(vGRE1,vGRE2,vGRE3)
,RGB(vYELL1,vYELL2,vYELL3)

)
)
)

topic Set Analysis/IF/RAG assistance required in QlikView

Set Analysis/IF/RAG assistance required