Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
trishita
Creator III
Creator III

Condition with colour functions

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?

5 Replies
olivierrobin
Specialist III
Specialist III

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
Creator III
Creator III
Author

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
Specialist III
Specialist III

you're right

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

trishita
Creator III
Creator III
Author

Hi,

the syntax is showing error in expression

trishita
Creator III
Creator III
Author