Discussion board where members can get started with QlikView.
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:
(Deviation after sounding==Difference Vs Log Survey) then green()
(Deviation after sounding - Difference Vs Log Survey ) !=0 then yellow()
red() //´(field='Correction Not Done')
I am not sure with the syntax.And where should I use to generate a graph with this function?
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([Deviation after sounding]=[Difference Vs Log Survey],
if([Deviation after sounding] - [Difference Vs Log Survey]<>0,
do I need this red in the above code as u had mentioned or was it a typo:
red() ---< is this a typo as I want red to be only when the field is Correction Not done
but you have to replace it by another color in case the above condition is false
the syntax is showing error in expression