Problem Color with Condition

[#1]

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.

[larouge69]

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