topic Re: Fill Pattern on Bar and/or Pie charts in QlikView

Fill Pattern on Bar and/or Pie charts

vlad_komarov — Mon, 15 Oct 2012 17:03:29 GMT

Hello,

Is it possible to change the fill pattern style for Bar and Pie charts expressions?

I've tried the Line Style, but it does not affect anything but lines width and style.

I could not find any other option in the chart properties to do that....

I need to have something like:

I would appreciate any suggestions.

Best regards,

Vladimir

Re: Fill Pattern on Bar and/or Pie charts

MayilVahanan — Mon, 15 Oct 2012 17:10:20 GMT

Properties->color->Select OnScreen and MultiColored option.

Hope that helps

Re: Fill Pattern on Bar and/or Pie charts

Gysbert_Wassenaar — Mon, 15 Oct 2012 17:15:18 GMT

No, there's no such option (at least not in QV 10). You can set the 'Use patterns Instead of Colors', but you have no control over which patterns are used.

Re: Fill Pattern on Bar and/or Pie charts

vlad_komarov — Mon, 15 Oct 2012 18:17:54 GMT

Does not look like they have it in QV 11 either.

Thanks!

Re: Fill Pattern on Bar and/or Pie charts

vlad_komarov — Mon, 15 Oct 2012 18:27:04 GMT

Thanks for reply, but this solution will not work for me:

1. It converts chart to B/W (unless I am missing something, the "Multicolored" option is disabled for the Bar Chart properties) and it is not giving me an option to change filling style.

2. As you can see below it works for line filling (for Symbols), but not for the Bar chart

3. And I need to change colors dynamically, so I am using Background Color option in Expression, but not Colors dialog on the chart properties.

Re: Fill Pattern on Bar and/or Pie charts

MayilVahanan — Mon, 15 Oct 2012 18:27:50 GMT

You can't select the pattern , but you can display the chart with stripes in it.. Please see the attached file...

Edit:

If you like to display with pattern in bar chart, please post a idea in qlikview community. So in future, they may be develop it..

Re: Fill Pattern on Bar and/or Pie charts

vlad_komarov — Mon, 15 Oct 2012 20:10:17 GMT

Thanks, but as I've mentioned above, I need to have different Patterns for different Expressions, ideally with colored background. It's strange that this basic functionality is still not available in QV. I will send a proposal to include it into one of the next releases.

Thanks for your input.

Regards,

Vladimir

Re: Fill Pattern on Bar and/or Pie charts

vlad_komarov — Tue, 16 Oct 2012 03:34:12 GMT

I have created an "idea" to implement this option in one of future QV releases:

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

Please vote for it, if you think it might be usefull.

Regards,

Vladimir

Re: Fill Pattern on Bar and/or Pie charts

vlad_komarov — Tue, 16 Oct 2012 03:34:29 GMT

I have created an "idea" to implement this option in one of future QV releases:

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

Please vote for it, if you think it might be usefull.

Regards,

Vladimir

Re: Fill Pattern on Bar and/or Pie charts

Tue, 04 Feb 2014 14:10:41 GMT

Hi,

Does anyone knows if defining patterns is still not possible? I saw the following tool from a QV partner so seems it is possible....

Also I wonder if there are patterns already created (when using patterns instead of colours option) then would it be possible to get the same logic/code and use it?

Many thanks in advance!

Re: Fill Pattern on Bar and/or Pie charts

vlad_komarov — Tue, 04 Feb 2014 21:45:49 GMT

Alejandra,

Do you have access to that tool? The screenshot you've sent has some similarity with standard QV charts, but I am guessing it's some special control developed by third party. I do not think the pattern option was made available in regular QV bar chart.

Regards,

Vladimir

Re: Fill Pattern on Bar and/or Pie charts

Wed, 05 Feb 2014 07:02:35 GMT

Hi Vladimir,

Thanks for your reply.I don't have access to the tool, I saw it in a webinar. Indeed it is developed by a third party. But at least that means it is possible right?

Best regards,

Alejandra

Re: Fill Pattern on Bar and/or Pie charts

vlad_komarov — Wed, 05 Feb 2014 15:31:02 GMT

It was (probably) done as an extension, so you have to pay extra or develop yourself something that easily could be done internally. QV has the pattern option available in many forms on multiple controls, but for some reason they have missed that in basic Bar Chart.

I am hoping that they will develop it in v.12, but I have some serious doubts considering the level of changes in the future version.

Regards,