Problem Color with Condition

Tue, 03 Feb 2015 09:54:13 GMT

Hi,

i meet a problem with a condition on a graph.

I calculate rate and when my condition DatePrePRo>Date then White else red.

But i note this condition doesn't run in somes cases.

I think Qlik pre calculate condition and if the condition will remain the same, Qlik actives the condition.

Expression:

if(DatePreProd>Date,RGB(255,255,255),
        if([Tx PV2 conformes]>=1,RGB(0,140,0),
                if([Tx PV2 conformes]<=0.79,RGB(240,0,0),
                        if([Tx PV2 conformes]>0.79 and [Tx PV2 conformes]<1,RGB(255,128,0)
                        )
                )
        )
)

Sorry for my english and thanks to your help.

Re: Problem Color with Condition

larouge69 — Wed, 04 Feb 2015 17:44:41 GMT

Bonjour

Est ce que tu as essayer de remplacer 0.79 (point) par 0,79 (virgule) ?

Si un problème de quote intervient tu peux faire : ....>=(79/100)

Merci

topic Problem Color with Condition in Francophones

Problem Color with Condition

Re: Problem Color with Condition