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?
If I haven't misplaced a parenthesis, try:
if(Deviation after sounding=Difference Vs Log Survey,green(),
if(Deviation after sounding - Difference Vs Log Survey <>0,yellow())),
You would put this in the Background color of the Chart Expression