Help with nested IF statement

darrellbutler — Wed, 31 Aug 2011 09:10:33 GMT

Hi, I'm having problems with the following nested if statement even though the syntax checker claims the expression is ok. Can anybody take alook and suggest a different approach / structure to the expression.

if($(#=VMatTurnover) = 0, 0,

if([ACCOUNTING_PERIOD] = 2, ($(#=VMatTurnover) / $(#=vMatTonnes) )
- Avg({$<[ACCOUNTING_PERIOD] = {$(#=ACCOUNTING_PERIOD-1), $(#=ACCOUNTING_PERIOD)},[ACCOUNTING_YEAR] = {$(#=ACCOUNTING_YEAR)}>} [Mature Cheddar]
+
sum({$<[ACCOUNTING_PERIOD] = {$(#=ACCOUNTING_PERIOD+10)},[ACCOUNTING_YEAR] = {$(#=ACCOUNTING_YEAR-1)}>} [Mature Cheddar])),

if([ACCOUNTING_PERIOD] = 1, ($(#=VMatTurnover) / $(#=vMatTonnes))
- Avg({$<[ACCOUNTING_PERIOD] = {$(#=ACCOUNTING_PERIOD)},[ACCOUNTING_YEAR] = {$(#=ACCOUNTING_YEAR)}>} [Mature Cheddar]
+
sum({$<[ACCOUNTING_PERIOD] = {$(#=ACCOUNTING_PERIOD+10), $(#=ACCOUNTING_PERIOD+11)}, [ACCOUNTING_YEAR] = {$(#=ACCOUNTING_YEAR-1)}>} [Mature Cheddar])),

($(#=VMatTurnover) / $(#=vMatTonnes))
- Avg({$<[ACCOUNTING_PERIOD] = {$(#=ACCOUNTING_PERIOD-1), $(#=ACCOUNTING_PERIOD-2), $(#=ACCOUNTING_PERIOD)},
[ACCOUNTING_YEAR] = {$(#=ACCOUNTING_YEAR)}>} [Mature Cheddar]))))

Regards

Darrell.

Help with nested IF statement

Wed, 31 Aug 2011 09:30:16 GMT

Hi,

Check if this helps: http://www.qlikblog.at/464/tool-creating-nested-ifstatements/

@Ungvall

Senior Business Discovery Manager at Advectas AB

topic Help with nested IF statement in QlikView

Help with nested IF statement

Help with nested IF statement