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

Show chart object with fixed pre-selected response from another question

Hey guys,

Hope you all doing great. I had a question and i was wondering if you could help me out,

I have two questions in my data:

1. What is your gender?

- Male

- Female

2. Do you like oranges or apples?

- Apples

- Oranges

How do i make a bar chart which shows Gender (both male and female) for only those who bought apples?

This selection (apples) should be fixed only for this chart object. The other charts must not be affected by this selection.

Thanks a lot guys!

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Assuming you have a field Customer and a field Product you can use this expression: count({<Product={'Apples'}>} Customer)

Change Customer and Product as appropriate to your situation. Use Gender as the dimension for the chart.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

Assuming you have a field Customer and a field Product you can use this expression: count({<Product={'Apples'}>} Customer)

Change Customer and Product as appropriate to your situation. Use Gender as the dimension for the chart.


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks a lot mate. I managed to figure it out from there.