Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
giasinga
Contributor
Contributor

Combo Chart won't Filter correctly

I am new to Qlik Sense. I hope you can understand my Question.

So I want a Combo Chart with stacked values. Right know I have this chart:

clipboard_image_0.png

It is working fine but I really want to have the Chart stacked. Like this:

clipboard_image_1.png

The Problem with the second combo chart is that it wont Change when I am using a Filter.  

Ideally I would like it to only show me a green bar when I am Filtering for product_cost5

 

My formula for product_cost1 is:                                sum({<[type]={'product1'}>}cost) 

same with the other ones except the           'product2'          'product3'              'product4'               'product5'

 

I hope I made the question somewhat clear. 

Labels (2)
1 Solution

Accepted Solutions
tomovangel
Partner - Specialist
Partner - Specialist

then can you try to write the expression in If 

 

like 

Sum(if(type='product1',cos))

 

 

View solution in original post

4 Replies
tomovangel
Partner - Specialist
Partner - Specialist

Hello, Giasinga

 

Can you try this expression

 

sum({$<[type]={'product1'}>}cost)

 

giasinga
Contributor
Contributor
Author

Hello Tomovangel,

I have already tried that way. It does not make a difference after using the filter.

tomovangel
Partner - Specialist
Partner - Specialist

then can you try to write the expression in If 

 

like 

Sum(if(type='product1',cos))

 

 

giasinga
Contributor
Contributor
Author

Yes that is the correct one. 

 

Thank You very much