topic Using Nested IF's in a chart in QlikView

Using Nested IF's in a chart

Wed, 07 Oct 2009 20:29:34 GMT

How I can nest these two If's


=if('Definition' & chr(10) & 'ABT-KEY' =above('Definition' & chr(10) & 'ABT-KEY'),'','Bezeichnung' & chr(10) & 'ADT-Schlüssel')


= if(len(O_POSITION.TEXTLANG)<30
,
 capitalize(O_POSITION.TEXTLANG) & chr(10) & chr(10)& ABT_KEY
,
 capitalize(O_POSITION.TEXTLANG) & chr(10) & ABT_KEY
)

Using Nested IF's in a chart

Wed, 07 Oct 2009 21:47:55 GMT

I will make it a little simple

if there are two if statements in an expression of a chart like this


if(x= above(X),'',X
and if(y>50,'+','-')

How can u combine and write so that both if's will work and the syntax is correct

Thanks

sravan

Using Nested IF's in a chart

stevedark — Wed, 07 Oct 2009 21:52:31 GMT

Hi there,

I'm not sure which way around you want to nest the if statements, but it should be something like this:

=if(Field = 'A', 'Field is A', if(Field = 'B', 'Field is B', 'Field is not A or B'))

Suggest using line breaks, and putting chunks of code into variables, to make things more readable.

Cheers,
Steve