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?

[olivierrobin]

hello

in your graph, expression tab

for each expression, if youpress then +,you have 2 options background color, text color

you can code an expression

if(field='Correction Done',

     if([Deviation after sounding]=[Difference Vs Log Survey],

        green(),

        if([Deviation after sounding] - [Difference Vs Log Survey]<>0,

             yellow(),

             red() 

          ),

        red() 

)

[trishita]

do I need this red in the above code as u had mentioned or was it a typo:

if(field='Correction Done',

     if([Deviation after sounding]=[Difference Vs Log Survey],

        green(),

        if([Deviation after sounding] - [Difference Vs Log Survey]<>0,

             yellow(),

             red()  ---< is this a typo as I want red to be only when the field is Correction Not done

          ),

        red() 

[olivierrobin]

you're right

but you have to replace it by another color in case the above condition is false

[trishita]

Hi,

the syntax is showing error in expression

[trishita]