topic Re: Re: Colored pattern in bar-chart in QlikView

Colored pattern in bar-chart

Wed, 10 Sep 2014 08:41:02 GMT

Hi,

How do I change the color a pattern in a bar chart? I know how to activate the patterns, but I have no idea how to color them. Is it even possible?

I also tried it with the background color in the expression, but this doesn't work either...

My expectation would be "the mix" of the two attached pictures...

Any idea?

Best regards,

Moritz

Re: Colored pattern in bar-chart

Siva_Sankar — Wed, 10 Sep 2014 08:55:52 GMT

Moritz,

I guess you have to use bar offset in your chart. click on the + in expression tab where you will find bar offset. Find the attached document. Might be helpful.

Re: Colored pattern in bar-chart

Wed, 10 Sep 2014 10:19:28 GMT

shankarece,

thank you for the quick response.

I guess you missunderstood me, I'll explain my problem again.

In my company we have some kind of tasks, called ESO (electronic service order). They are registered in a program which records the time it takes our employee to complete the task. In this chart i am trying to visualise the time period for each type of task. The time period is split in to the 'waiting period' (time it takes till someone takes care of the task) and the processing time (time it takes the employe to finish the task). I would like to display these two in different colors.

Now here's the problem:

As we have several departments in our company and each of these departments has different types of tasks, I need to visualise these several departments. This would mean, I'd like to have some patterns to differentiate our departments. So far so good, would be no problem. But if I activate the pattern, the bars loose their color.

So what am I supposed to do?

About your attached file I need to say, that the problem (bar color) didn't occur there...

The only difference I can find is that I use an expression for the bar color in my document and you don't...

Thanks for your incredibly quick response anyway!

I hope you can help me anyway...

Best regards (and sorry for my very bad english, I am swiss...)

Moritz

Re: Re: Colored pattern in bar-chart

Siva_Sankar — Wed, 10 Sep 2014 11:44:27 GMT

Like the attached one you want? !

Re: Colored pattern in bar-chart

Wed, 10 Sep 2014 12:16:52 GMT

I miss the pattern in your example.

Imagine each year bar with a different pattern.

But I guess it's not possible so far...

Re: Colored pattern in bar-chart

Siva_Sankar — Wed, 10 Sep 2014 12:33:41 GMT

Moritz,

I understood now. You want to display different pattern(like different colour) for each bars in the chart. As far as i know there is no option to have different pattern for different bars. However, you can refer the thread hereFill Pattern on Bar and/or Pie charts

http://community.qlik.com/ideas/2697

Re: Colored pattern in bar-chart

Colin-Albert — Wed, 10 Sep 2014 12:39:03 GMT

As I understand it, the options for bars is either colours or black & white patterns.

The patterns are designed as an option for printing colour charts on black & white printers.

There is no option for coloured patterns, only for different colours.

Re: Colored pattern in bar-chart

Wed, 10 Sep 2014 12:45:20 GMT

Yes, that was exactly my idea.

Thank you for your help and for the links to the other topics.

I wish you a nice day!

Best regards,

Moritz

Re: Colored pattern in bar-chart

Wed, 10 Sep 2014 12:49:46 GMT

Thank you for your answer Colin.

Now I understand why this option is missing, makes totally sense.

I will use the patterns correct now

Wish you a nice day!

Moritz