1 Reply Latest reply: Feb 4, 2015 12:47 PM by David B. RSS

    Problem Color with Condition

    julien saint maxent

      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.