topic Escaping nested if statements in QlikView

Escaping nested if statements

Wed, 14 Jan 2015 16:12:58 GMT

Hi all,

I want to make a sum based on two conditions, for example if it is the current month and if the weather is sunny, sum all sales.

What's the best practice and most efficient way of achieving this in Qlikview?

Cheers,

marcus_malinow — Wed, 14 Jan 2015 16:18:02 GMT

Hi David,

One possible approaches is to use Set Analysis. This is far more efficient than If conditions when used in front end expressions.

For example:

sum({$<Month={'$(=Month(Now())'}, Weather={'Sunny'}>} Sales)

Marcus

Anonymous — Wed, 14 Jan 2015 16:19:32 GMT

There is no need for nesting, it is simply

if(month = current month AND weather = sunny, expression for true, expression for false)

consenit — Wed, 14 Jan 2015 16:27:03 GMT

Hi there.

I'd favor Set Analysis over IF statements almost any time:

=SUM({$<Wheater={'Sunny'}, Month={$(=MONTH(TODAY()))}>} Sales)

Kind regards,

Ernesto.

richard_chilvers — Wed, 14 Jan 2015 16:40:45 GMT

David

Is it the case that you might have many combinations of conditions?

For example:

Current Month AND Sunny ...

Current Month AND Raining ....

Current Month AND Windy .....

Last Month AND Was Sunny ....

I agree nested IFs would get messy.

I'd be interested in views. Where appropriate, I try to deal with conditions like this in the script; it can often be handled more elegantly there.

Regards

Wed, 14 Jan 2015 16:43:08 GMT

Thanks all - done a little testing with Set Analysis and I am really impressed. Tidier and performs more efficiently than the IF AND statements.