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
Did you mean:
Contributor

how to sum by product dynamically

 salesman product quantity Total A N1 2 9 B N1 3 9 C N1 4 9 A N2 4 15 B N2 5 15 C N2 6 15 A N3 6 21 B N3 7 21 C N3 8 21

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,

 salesman product quantity Total A N1 2 5 B N1 3 5 A N2 4 9 B N2 5 9 A N3 6 13 B N3 7 13

how to write the formula for new Total

2 Solutions

Accepted Solutions
MVP

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

- quantity: Sum(quantity)

- Total: Sum(TOTAL <product> quantity)

MVP

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
3 Replies
MVP

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

- quantity: Sum(quantity)

- Total: Sum(TOTAL <product> quantity)

Contributor
Author

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

MVP

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
Tags
Community Browser