topic Re: Condition with colour functions in QlikView

Condition with colour functions

trishita — Wed, 25 Nov 2020 16:16:04 GMT

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 — Fri, 18 May 2018 15:18:20 GMT

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()

)

trishita — Fri, 18 May 2018 15:46:00 GMT

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 — Fri, 18 May 2018 15:50:47 GMT

you're right

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

trishita — Fri, 18 May 2018 16:19:31 GMT

Hi,

the syntax is showing error in expression

trishita — Fri, 18 May 2018 16:24:30 GMT