topic Re: Bar chart background color in QlikView

Bar chart background color

shanky1907 — Tue, 31 Oct 2017 12:20:40 GMT

Hello All,

I have a problem with my Bar chart like:

1) I have a Dimension as 'Category'.

2)In the expression, i have given specific colors(in the background color of the expression) to every bar according to value of the Dimension as:

=Pick(Match(Category,'Your Company','Your Customers','Your Processes','Your Responsibilities','Your Role','Overseer'),rgb(241,115,115),rgb(98,176,255),rgb(255,140,55),rgb(0,101,149),rgb(11,147,116),rgb(126,138,146))

3)It works perfectly fine wheni select any month which has data for it. But when there is not data in the moneht selected then all bars show single default color.

I want to keep the color as it required if there is no data also.

*NOTE: In my expression i am calculating rolling YTD data.

Re: Bar chart background color

prat1507 — Tue, 31 Oct 2017 12:23:58 GMT

Use this

=Pick(Match(Only({1}Category),'Your Company','Your Customers','Your Processes','Your Responsibilities','Your Role','Overseer'),rgb(241,115,115),rgb(98,176,255),rgb(255,140,55),rgb(0,101,149),rgb(11,147,116),rgb(126,138,146))

Re: Bar chart background color

sunny_talwar — Tue, 31 Oct 2017 12:25:08 GMT

Try this

=Pick(Match(Only({1} Category), 'Your Company', 'Your Customers', 'Your Processes', 'Your Responsibilities', 'Your Role', 'Overseer'), RGB(241,115,115), RGB(98,176,255), RGB(255,140,55), RGB(0,101,149), RGB(11,147,116), RGB(126,138,146))

Re: Bar chart background color

shanky1907 — Tue, 31 Oct 2017 12:29:16 GMT

Excellent!! Thanks..

Re: Bar chart background color

shanky1907 — Tue, 31 Oct 2017 12:29:32 GMT

Thank Sunny for the quick response.