Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

List Box and Charts

Hi

I have a list lox which has three values, let's assume 'Country', 'Sale amount' and 'Product' also have 3 charts C1, C2 and C3. What I am trying to do is when I select 'Product' nothing should happen in chart C1 but in C2 and C3. Can anyone please help how can I achieve this.

7 Replies
Highlighted
Esteemed Contributor III

Re: List Box and Charts

In your chart expression use set analysis like:

Chart1

Expr: = Sum({< Product = >} YourField)

Do this for all the 3 charts. If this is not what you looking for can you share your expr or a sample to work on.

Highlighted
Esteemed Contributor III

Re: List Box and Charts

Or This?

Chart1

Expr: = Sum({< YourListBox -= {'Product'} >} YourField)

Highlighted
Not applicable

Re: List Box and Charts

Thanks Vishwarath. I am new in working on charts, just to elaborate more, I have attached a sample wherein I need.. if any of the list item is selected from Product list should not affect bar chart but only show the changes in pie chart.

Let me know if this is clear.

Highlighted
Contributor

Re: List Box and Charts

Hello Hina,

Try this.

Highlighted
Not applicable

Re: List Box and Charts

This works!! Thanks Rohit and Vishwarath

Highlighted
Esteemed Contributor III

Re: List Box and Charts

In your Bar Graph properties add set analysis to ignore product field like :

Capture.PNG

Highlighted
Esteemed Contributor III

Re: List Box and Charts

Great. Can you close the thread marking correct/helpful responses.