Better alternative to nested if statement

Wed, 24 Sep 2014 16:23:23 GMT

Hi everyone,

I have a file that uses nested if statement. At the moment this is not a problem since I'm working with a small sample, but for the final version I'll need about 53 statements.

I'm using this expression in a straight table to calculate wks sup. For every week, I need to compare the current inventory to the aggregate sum of forecasts for all the weeks before.

I'm trying to find a more efficient way.

This is the code in the smaller sample:

if(sum([inventory - current])=0,0,

if(sum([inventory - current])>sum(forecast),'>year',

if(sum([inventory - current])<sum(if([calc week]<=1,forecast)),0,

if(sum([inventory - current])<sum(if([calc week]<=2,forecast)),1

,2))

))

Is there a way to rewrite this without the nested if statemets?

Thanks

Re: Better alternative to nested if statement

vgutkovsky — Wed, 24 Sep 2014 19:48:01 GMT

Well, a better way would be to take a lot of the logic to the script and create flags that could then be referenced in the UI expressions. If you're determined to do it purely in the UI and just want to avoid manually typing a huge expressions, see attached.

Regards,

Vlad

topic Re: Better alternative to nested if statement in QlikView

Better alternative to nested if statement

Re: Better alternative to nested if statement