topic Re: bar chart color in QlikView

bar chart color

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

Whenever we use 2 expressions in a bar chart, 2 different colors are taken for both the expressions to display them. In my case one of those 2 expressions is invisible. So chart is having single color.

Is there any way to give different colors to the bars belonging to same expression?

Thanks

Re: bar chart color

kaushiknsolanki — Wed, 13 Nov 2013 06:49:58 GMT

Hi,

Try Multicolor Option under Color Tab.

Regards,

Kaushik Solanki

Re: bar chart color

Wed, 13 Nov 2013 06:52:53 GMT

Hi,

Multi colored option will not come when I have 1 invisible and other visible expressions.

Thanks

Re: bar chart color

kaushiknsolanki — Wed, 13 Nov 2013 06:55:22 GMT

Hi,

Instead of Invisible, why dont u hide the expression.

When you hide one expression even on condition, it will work.

Regards,

Kaushik Solanki

Re: bar chart color

Wed, 13 Nov 2013 06:57:57 GMT

Hi,

You mean to say I have to disable current invisible expression ?

Thanks

Re: bar chart color

MK_QSL — Wed, 13 Nov 2013 06:58:34 GMT

Kaushik's suggestion is the best one. You can disable one of the expression by removing tick from ENABLE.

But in case if you still persist to keep the second expression as invisible (may be because you want both expression while exporting to excel)... click on + sing in expression tab and under background colour, write an expression to show different color.. something like below.

if(SUM(QTY) < 400, GREEN(),

iF(SUM(QTY) < 600, RED(), QlikTechGray()))

Re: bar chart color

kaushiknsolanki — Wed, 13 Nov 2013 06:59:38 GMT

Hi,

Not disable, you can use the "conditional" option available under expression tab.

So you can conditionally enable or disable the expression.

Regards,

Kaushik Solanki

Re: bar chart color

Wed, 13 Nov 2013 07:01:29 GMT

Re: bar chart color

Wed, 13 Nov 2013 07:02:08 GMT

There is no condition for it. I want it to be invisible always.

Re: bar chart color

kaushiknsolanki — Wed, 13 Nov 2013 07:03:36 GMT

Hi,

Then disable it, if its not visible whats the use of having that.

Regards,

Kaushik Solanki

Re: bar chart color

Wed, 13 Nov 2013 07:04:47 GMT

There is difference between disabling and making an expression invisible.

When we make an expression as invisible, the expression will be evaluated and graph will be changed accordingly but it wont be displayed. Disabling an expression is as good as not having that expression which wont meet my requirement. I have written invisible expression to change scale and spacing of bars in chart. Which cannot be done in main expression as it uses dual.

Re: bar chart color

kaushiknsolanki — Wed, 13 Nov 2013 07:06:11 GMT

Hi,

I agree, but what is that expression which you are keeping invisible, whats your requirement.

Regards,

Kaushik Solanki

Re: bar chart color

Wed, 13 Nov 2013 07:10:43 GMT

I had discussed it earlier on community and that is the way I could find. So now lets find a way to give different colors for the bars in chart without removing invisible expression.

Re: bar chart color

kaushiknsolanki — Wed, 13 Nov 2013 07:11:37 GMT

Hi,

I dont think its possible with two expression.

Regards,

Kaushik Solanki

Re: bar chart color

Wed, 13 Nov 2013 07:14:15 GMT

try it go copy and paste in colour tab