Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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

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)

 

View solution in original post

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

View solution in original post