topic Re: Nested if in load script error in QlikView

Nested if in load script error

apthansh — Wed, 25 Nov 2020 16:16:04 GMT

Load,

[ ID Key],

CPKey,

Sum(IF(sum(if(CYQ='Q'&ceil(Month(Today())/3)&'_'& year(Today()),Comm)) <=0,

sum(if(CPYQ='Q'&ceil(Month(Today())/3)&'_'& year(Today()),CommPlan)),

sum(if(CYQ='Q'&ceil(Month(Today())/3)&'_'& year(Today()),Comm)))) as SF

Resident SF

Group by [ID Key],

CPKey;

Drop Table SF;

I a using the above script and I am getting error saying cannot do nested aggregation is not allowed ? Cant I do it or I am doing something wrong here ?

Re: Nested if in load script error

sunny_talwar — Fri, 29 Sep 2017 15:16:24 GMT

May be this

LOAD [ ID Key],

CPKey,

If(Sum(if(CYQ='Q'&ceil(Month(Today())/3)&'_'& year(Today()),Comm)) <= 0,

Sum(if(CPYQ='Q'&ceil(Month(Today())/3)&'_'& year(Today()), CommPlan)),

Sum(if(CYQ='Q'&ceil(Month(Today())/3)&'_'& year(Today()),Comm))) as SF

Resident SF

Group by [ID Key], CPKey;

DROP Table SF;

Re: Nested if in load script error

apthansh — Fri, 29 Sep 2017 15:28:31 GMT

How Silly..I just missed the if !!

Thank you very much.You are a rockstar !!

Re: Nested if in load script error

sunny_talwar — Fri, 29 Sep 2017 15:29:19 GMT

You didn't miss an if... but you had an extra Sum()

Re: Nested if in load script error

apthansh — Fri, 29 Sep 2017 19:42:22 GMT

Yup !!