topic Re: How to maintain the consistent color schemes when selected with out filtering the bars in a bar chart? in QlikView

How to maintain the consistent color schemes when selected with out filtering the bars in a bar chart?

vkolasani — Tue, 29 Mar 2016 15:53:14 GMT

Hello All,

I have below scenario:

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.

Any help would be highly appreciated.

Thanks,

Venu

Re: How to maintain the consistent color schemes when selected with out filtering the bars in a bar chart?

sunny_talwar — Tue, 29 Mar 2016 16:40:52 GMT

Can you share a qvw file which you might have been working with?

Re: How to maintain the consistent color schemes when selected with out filtering the bars in a bar chart?

kkkumar82 — Tue, 29 Mar 2016 16:48:25 GMT

Hi ,

As far I have understood for the first bar chart change the style to " LED" or Check boxes then your chart won't fade out.

Hope this helps you.

Kiran

Re: How to maintain the consistent color schemes when selected with out filtering the bars in a bar chart?

vkolasani — Tue, 29 Mar 2016 16:56:00 GMT

Hi Sunny,

Please find the attached workbook.

Note: The filtering and color scheme should be remains across all 3 charts.

Thanks,

Venu

Re: How to maintain the consistent color schemes when selected with out filtering the bars in a bar chart?

sunny_talwar — Tue, 29 Mar 2016 22:43:15 GMT

See if attached is what you are aiming for:

Re: How to maintain the consistent color schemes when selected with out filtering the bars in a bar chart?

vkolasani — Wed, 30 Mar 2016 12:31:44 GMT

Thank you Sunny for your work on this.

However, When i checked the Technology Blue color it is changing the colors (Not showing the true colors) of Furniture and Office Supplies.

I tried different approaches missing something.

Thanks,

Venu