topic color If logic help in QlikView

color If logic help

mahitham — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Can any one please help me on below if logic to apply Grey Color.

I have a Flag with records 1 and 0.

When $(vCount)/$(vTotalCount))>'20%' and $(Count)>5 and Flag=1,Green(),

When $(vCount)/$(vTotalCount))>'20%' and $(Count)>5 and Flag=0,Red() else its Grey().

Please help me to apply Grey() in the below if logic.

Aggr(

if( ($(vCount)/$(vTotalCount))>'20%' and $(Count)>5 and Prod1Flag=1,Green(),

if( ($(vCount)/$(vTotalCount))>'20%' and $(Count)>5 and Prod1Flag=0,Red())),Prod1Flag,Dim1,Dim2)

Thanks in advance

Re: color If logic help

Brett_Bleess — Tue, 16 Jul 2019 13:09:19 GMT

Did you try the following:

Aggr(

if( ($(vCount)/$(vTotalCount))>'20%' and $(Count)>5 and Prod1Flag=1,Green(),

if( ($(vCount)/$(vTotalCount))>'20%' and $(Count)>5 and Prod1Flag=0,Red(),Grey())),Prod1Flag,Dim1,Dim2)

I am no developer, so I do not know if this is correct or not, but I believe that should account for things that do not match the first two conditions becoming grey in color. Sorry if I am missing something here, if that is the case, if you can provide further details, or even a sample app, that may help others help you...

Regards,
Brett