Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
msmichael
New Contributor III

Bar chart with part of bars filled with color

Hi expert, 

Could anyone please let me know how I can create a bar chart like below in QV?

bar.png

I created the above chart in excel, the last two bars are not filled with colors. I did this by editing the data point. How can I do the same in QV?

 

Thanks,

Michael

Labels (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Bar chart with part of bars filled with color

Like this?

Capture.PNG

3 Replies
NW1965
Contributor

Re: Bar chart with part of bars filled with color

u should be able to do this by expanding the expression in the expression tab of your chart properties, then going to the background colour and creating an expression in there to control the colour.

For example:

IF(DimensionValue = {'1Q18','2Q18','3Q18','4Q18','1Q19','2019TD'} , RGB (0,0,255) , RGB(0,0,0) )

 

Note: I might not have the syntax exactly right for the test on the dimension values, you may need to use the match function here, but the principles are there to change the colour using the background expression.

MVP
MVP

Re: Bar chart with part of bars filled with color

Like this?

Capture.PNG

msmichael
New Contributor III

Re: Bar chart with part of bars filled with color

Hi,

thanks, this is exactly what I want.