QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save \$300 before February 6: REGISTER NOW!
cancel
Showing results for
Did you mean:
Master II

Sub Total using aggr() with Dimensionality?

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))

)

1 Solution

Accepted Solutions
MVP

try

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

2 Replies
MVP

try

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

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Community Browser