Help with nested IF statement

[darrellbutler]

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.

[#2]

Hi,

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

@Ungvall

Senior Business Discovery Manager at Advectas AB