topic Re: Show chart object with fixed pre-selected response from another question in QlikView

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

Sat, 17 Nov 2012 05:56:43 GMT

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!

Gysbert_Wassenaar — Sat, 17 Nov 2012 08:55:07 GMT

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.

Sat, 17 Nov 2012 13:23:19 GMT

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