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: 
Not applicable

Bar Chart dynamic expression qlik sense

Hi Guys,

I have a following bar chart, that represents percentage of product sold by Sales Reps. So the below chart would tell me that brown products are old more then the pink product.

Stacked.png

Problem: When I click on a single product then every bar becomes 100% like it shows below

selected.png

Instead of all 100% I would like to see comparison between reps. Is it possible?

1 Solution

Accepted Solutions
sunny_talwar

Assuming you current expression is like this

Sum(Sales)/Sum(TOTAL <[Sales Rep]> Sales)

Add this in there

Sum(Sales)/Sum(TOTAL <[Sales Rep]> {<Product>} Sales)

View solution in original post

2 Replies
sunny_talwar

Assuming you current expression is like this

Sum(Sales)/Sum(TOTAL <[Sales Rep]> Sales)

Add this in there

Sum(Sales)/Sum(TOTAL <[Sales Rep]> {<Product>} Sales)

Not applicable
Author

Thank you Shani Dev