topic Re: Sub Total using aggr() with Dimensionality? in QlikView

Sub Total using aggr() with Dimensionality?

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

Hi All,

Issue with partial sub total but able to get peak sold qty, please help me on the below expression. thanks

Peak sold qty

=If(Dimensionality()=1,

max({<Week_No=,Week_No,Batch,ArticleNo>} aggr(sum({<Week_No=,Week_No,ArticleNo>}Sold_Qty),Week_No,Batch,ArticleNo)),

max({<Week_No=,Week_No,Batch,ArticleNo>} aggr(sum({<Week_No=,Week_No,ArticleNo>}Sold_Qty),Week_No,Batch,ArticleNo))

)

maxgro — Mon, 07 Nov 2016 18:41:48 GMT

try

sum(aggr(max(Sold_Qty), ArticleNo, Batch))

kaushiknsolanki — Mon, 07 Nov 2016 18:45:20 GMT

Hi,

Try this.

Sum(Aggr(max({<Week_No=,Week_No,Batch,ArticleNo>} aggr(sum({<Week_No=,Week_No,ArticleNo>}Sold_Qty),Week_No,Batch,ArticleNo)),ArticleNo,Batch))

Regards,

Kaushik Solanki