Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
grant_S
Contributor
Contributor

how to sum by product dynamically

salesmanproductquantityTotal
AN129
BN139
CN149
AN2415
BN2515
CN2615
AN3621
BN3721
CN3821

i have above table, and want to have a new sum when filter the salesman, my expectation as below:

filter salesman A and B, total should be changed base on current view,

salesmanproductquantityTotal
AN125
BN135
AN249
BN259
AN3613
BN3713

 

 

how to write the formula for new Total

2 Solutions

Accepted Solutions
rubenmarin

Hi, I think this is a table with salesman and product as dimensions and 2 expressions:

- quantity: Sum(quantity)

- Total: Sum(TOTAL <product> quantity)

 

View solution in original post

MayilVahanan

Hi

Expression: Sum(TOTAL<product> quantity)

Not in set analysis like Sum(TOTAL {<product>} quantity), its means ignore Product selection.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

3 Replies
rubenmarin

Hi, I think this is a table with salesman and product as dimensions and 2 expressions:

- quantity: Sum(quantity)

- Total: Sum(TOTAL <product> quantity)

 

grant_S
Contributor
Contributor
Author

11.png

 

it cannot work as expected, directly sum the total but not by product.

MayilVahanan

Hi

Expression: Sum(TOTAL<product> quantity)

Not in set analysis like Sum(TOTAL {<product>} quantity), its means ignore Product selection.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.