Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

bar chart color

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

14 Replies
kaushik_solanki
Not applicable

Re: bar chart color

Hi,

     Try Multicolor Option under Color Tab.

Regards,

Kaushik Solanki

Not applicable

Re: bar chart color

Hi,

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

Thanks

kaushik_solanki
Not applicable

Re: bar chart color

Hi,

     Instead of Invisible, why dont u hide the expression.

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

Regards,

Kaushik Solanki

Not applicable

Re: bar chart color

Hi,

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

Thanks

MK_QSL
Not applicable

Re: bar chart color

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()))

kaushik_solanki
Not applicable

Re: bar chart color

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

Not applicable

Re: bar chart color

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.

Not applicable

Re: bar chart color

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

kaushik_solanki
Not applicable

Re: bar chart color

Hi,

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

Regards,

Kaushik Solanki