Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER 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?

1 Reply
m_woolf
Master II
Master II

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