Skip to main content

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 
Search instead for 
Did you mean: 
devarasu07
Master II
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))

  )

Peak sold Qty Total_1.JPG

1 Solution

Accepted Solutions
maxgro
MVP
MVP

try

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

1.png

View solution in original post

2 Replies
maxgro
MVP
MVP

try

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

1.png

kaushiknsolanki

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".