topic Re: List Box and Charts in QlikView

List Box and Charts

Tue, 05 Sep 2017 16:17:20 GMT

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.

Re: List Box and Charts

vishsaggi — Tue, 05 Sep 2017 16:40:10 GMT

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.

Re: List Box and Charts

vishsaggi — Tue, 05 Sep 2017 16:42:03 GMT

Or This?

Chart1

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

Re: List Box and Charts

Wed, 06 Sep 2017 08:17:00 GMT

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.

Re: List Box and Charts

rohitraut — Wed, 06 Sep 2017 10:43:15 GMT

Hello Hina,

Try this.

Re: List Box and Charts

Wed, 06 Sep 2017 11:24:41 GMT

This works!! Thanks Rohit and Vishwarath

Re: List Box and Charts

vishsaggi — Wed, 06 Sep 2017 14:13:15 GMT

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

Re: List Box and Charts

vishsaggi — Wed, 06 Sep 2017 15:23:49 GMT

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