topic Using NEST IF statements in QlikView

Using NEST IF statements

Fri, 06 Apr 2012 16:27:34 GMT

I was having some problems getting nested IF statements to work and I thought this maybe helpful to others.

I wanted to change the default background colour in a column in a table based on the value in the column and this was the structure of the IF statement that worked for me.

=IF(
'CONDITION 1'
, 'ACTION 1'
,IF('CONDITION 2'
,'ACTION 2'
,IF('CONDITION 3'
,'ACTION 3'
,'DEFAULT ACTION'
)
)
)

Using NEST IF statements

CELAMBARASAN — Fri, 06 Apr 2012 16:37:05 GMT

Hi,

Sometimes this may also helpfull for others.

=Pick(WildMatch(FieldName or Expression,'Value1','Value2','Value*','*'),'Action1','Action2','Action3','Action4')

Celambarasan