topic Re: How to Avoid disappearing the bars in Bar chart when one of the Bar is selected? in QlikView

How to Avoid disappearing the bars in Bar chart when one of the Bar is selected?

vkolasani — Thu, 28 Jan 2016 20:24:15 GMT

Hello Techies,

They way qlikview works is when select/click on the bar of the bar chart, bar chart would only display the selected bar and all other bars would disappear. Is there an way that we can avoid that? Is there any way that we can still show the other bars (may be not highlighted)?

Thanks,

Venu

Re: How to Avoid disappearing the bars in Bar chart when one of the Bar is selected?

sunny_talwar — Thu, 28 Jan 2016 20:40:18 GMT

You can def. do that.

Check out the attached where selected country remains green and the other bar turns blue

Re: How to Avoid disappearing the bars in Bar chart when one of the Bar is selected?

vkolasani — Thu, 28 Jan 2016 20:43:58 GMT

Sunny.

If we can do that, Is there a way? I have 3 bar charts which are in hierarchy. If I select one It will filter out the respective ones in other bar charts, we don't want other bars to be disappeared in all other respective charts.

Could you please provide the steps, if you have?

Thanks,

Venu

Re: How to Avoid disappearing the bars in Bar chart when one of the Bar is selected?

sunny_talwar — Thu, 28 Jan 2016 21:01:15 GMT

Not sure I understand. Would you be able to draw me a picture here

Re: How to Avoid disappearing the bars in Bar chart when one of the Bar is selected?

bgerchikov — Thu, 28 Jan 2016 21:30:56 GMT

Hi Venu,

There are couple possible solutions:

1. Use Alternate state for every chart

2. Create additional fields Country1, Country2, Country3 etc.

Please review attached

Re: How to Avoid disappearing the bars in Bar chart when one of the Bar is selected?

vkolasani — Tue, 29 Mar 2016 15:36:39 GMT

Sorry all for the delayed response and thanks for your reply. I will post a detailed scenario with all the details.

Thanks,

Venu

Re: How to Avoid disappearing the bars in Bar chart when one of the Bar is selected?

vkolasani — Tue, 29 Mar 2016 15:48:54 GMT

Hi Sunny,

Thanks for your reply. I am posting a detailed scenario with all the details.

I have 3 dimensions and a measure.

1. Category

2, Sub Category

3. Product Name

4. Sales (Measure)

I am trying to display the charts using the above dimensions and measures as shown below.

Above all 3 charts are colored by Category. If I select Technology under category chart other two bar charts should display the respective values and color as shown below and most importantly the Category chart should not filter out other two categories when Technology is selected and display the Furniture and Office supplies categories with the true colors (though grayed out) as shown below.

I am also attaching the sample data file as well.

Any help would be highly appreciated.

Thanks,

Venu