Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
trishita
Contributor 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?

1 Reply
Highlighted
mwoolf
Honored Contributor II

Re: Condition with colour functions

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