QlikView App Dev

[trishita]

I have two parameters and want to create  an expression with condition cases and colour background on basis of it

It would be kind of nested IF loop:

if(field='Correction Done')

then

   case 1:

    (Deviation after sounding==Difference Vs Log Survey) then green()

case 2:

    (Deviation after sounding - Difference Vs Log Survey ) !=0 then yellow()

else

   red()  //´(field='Correction  Not  Done')

I am not sure with the syntax.And where should I use to generate a  graph with this function?

[m_woolf]

If I haven't misplaced a parenthesis, try:

if(field='Correction Done'),

    if(Deviation after sounding=Difference Vs Log Survey,green(),

    if(Deviation after sounding - Difference Vs Log Survey <>0,yellow())),

   red())

You would put this in the Background color of the Chart Expression