topic Multiple Colors In 1 Single Bar Of A Bar Chart in QlikView

Multiple Colors In 1 Single Bar Of A Bar Chart

s10157754 — Wed, 25 Nov 2020 16:16:04 GMT

Dear Qlikview Experts,

I was thinking is it possible for Qlikview to achieve multiples colors in 1 single bar within a bar chart diagram? There is only 1 dimension and 1 expression. For example, sum(A) / sum(B).

If the bar is 90%, then 0%-30% should be green, 31%-60% should be yellow and 61%-90% should be red. So is it possible for it to have different color representation for individual range of %?

Something like the picture shown below? Thanks for your help in advance!

Re: Multiple Colors In 1 Single Bar Of A Bar Chart

MK_QSL — Fri, 06 Apr 2018 08:48:45 GMT

In this case you have to use 3 expressions.

Re: Multiple Colors In 1 Single Bar Of A Bar Chart

ananyaghosh — Fri, 06 Apr 2018 09:08:42 GMT

HI,

Are you want to show the single bars with 3 different colors? or at different bars with different colors?

Thank,

Sandip

Re: Multiple Colors In 1 Single Bar Of A Bar Chart

s10157754 — Sat, 07 Apr 2018 00:31:53 GMT

Dear Kachhia,

Sorry for the late reply. I only have 1 expression, so I was looking for some functions there are able to display different colors for individual range of %.

Best Regards

Re: Multiple Colors In 1 Single Bar Of A Bar Chart

s10157754 — Sat, 07 Apr 2018 00:33:02 GMT

Dear Sandip,

Sorry for the late reply, I was looking for a way to show the single bar with 3 different colors.

Best Regards

Re: Multiple Colors In 1 Single Bar Of A Bar Chart

Anil_Babu_Samineni — Sat, 07 Apr 2018 14:59:04 GMT

Yes, For single expression copy three times to get 3 different colors in single Graph

Re: Multiple Colors In 1 Single Bar Of A Bar Chart

MarcoWedel — Sat, 07 Apr 2018 23:34:56 GMT

Hi,

solutions might be either

a bar chart with additional synthetic dimension like this:

or a straight table with linear gauge representation of your expression:

hope this helps

regards

Marco

Re: Multiple Colors In 1 Single Bar Of A Bar Chart

s10157754 — Thu, 19 Apr 2018 08:35:46 GMT

Dear Marco,

Thank you so much for the solution and it works perfectly for me!

Best Regards

QianNing