topic nested aggregation not allowed in QlikView

nested aggregation not allowed

agni_gold — Sun, 02 Jul 2017 00:38:54 GMT

Hi Friends,

(sum({<[Planning Versions]={"$(=Right(Year(Today()),1)&Num(vG_FN_CurrentMonth-1,'00'))"}>}

[Sales Plan in KS]*(if(ASP=0 and PLC=6.2 , Max(PMIN),ASP))))

is there any alternative?

Re: nested aggregation not allowed

Anil_Babu_Samineni — Sun, 02 Jul 2017 01:34:31 GMT

Looks like better approach only, try this?

(sum({<[Planning Versions]={"$(=Right(Year(Today()),1)&Num(vG_FN_CurrentMonth-1,'00'))"}>}

[Sales Plan in KS])*sum({<ASP = {0}, PLC ={'6.2'}, PMI={'$(=max(PMI))'}>}ASP))

Re: nested aggregation not allowed

agni_gold — Sun, 02 Jul 2017 07:15:46 GMT

sum({<ASP = {0}, PLC ={'6.2'}, PMI={'$(=max(PMI))'}>}ASP))

and

if(ASP=0 and PLC=6.2 , Max(PMIN),ASP))

are same?

Re: nested aggregation not allowed

agni_gold — Sun, 02 Jul 2017 07:43:45 GMT

gwassenaar‌ , any help, please.

Re: nested aggregation not allowed

Anil_Babu_Samineni — Sun, 02 Jul 2017 08:40:24 GMT

I've notice now. Two are not the same and this condition works as same when you apply max statement in first expression then you may get answer. Let's wait sunny response stalwar1‌

Re: nested aggregation not allowed

vishsaggi — Sun, 02 Jul 2017 18:45:58 GMT

Try this may be:

= sum({<

[Planning Versions] = { "$(=Right(Year(Today()),1)&Num(vG_FN_CurrentMonth-1,'00'))"}

>} [Sales Plan in KS]

) * if(ASP = 0 and PLC = 6.2 , Max(PMIN), ASP)

Re: nested aggregation not allowed

agni_gold — Sun, 02 Jul 2017 19:30:09 GMT

will it do row by row multiplication?

Re: nested aggregation not allowed

vishsaggi — Sun, 02 Jul 2017 19:42:16 GMT

Did you try, it should. What chart object are you using?