topic Re: barchart in QlikView

barchart

Fri, 14 Mar 2014 09:10:49 GMT

Hi all

I have one requirement

i have to create a bar chart and half of the bars should show one color remaining half bars should show another color

how can we do plz help

Regards

Panireddy

Re: barchart

Fri, 14 Mar 2014 09:14:53 GMT

Hi,

CAn you please eloborate your requirement ....with sample file or data

Regards

Nani

Re: barchart

Fri, 14 Mar 2014 09:15:00 GMT

Hi Panireddy,

The easiest option is to set the colors in "Colors" tab.

Right click on the chart, go to Properties--Colors tab and in the "Data Appearance" section you can customize the colors for the bar.

Hope this helps. Otherwise, please add a sample file.

Re: barchart

MK_QSL — Fri, 14 Mar 2014 09:15:37 GMT

Creat a bar char

example

Dimension = Customer

Expression1 = SUM(Sales)/2

Expression2 = SUM(Sales)/2

Now go to Style tab and select Stacked.

UPDATE : Please check enclosed file...

Re: barchart

sunilkumarqv — Fri, 14 Mar 2014 09:19:50 GMT

Hi Pn Reddy,

Go to properties - Style - Choose -subtype as stacked it works but should have more then on expression in your chart

If not these .more specific what you want so it easy to solve

Re: barchart

jsingh71 — Fri, 14 Mar 2014 09:20:38 GMT

Hi,

First you add two expressions and after that go to chart properties and select stacked option.

Re: barchart

Fri, 14 Mar 2014 09:29:20 GMT

Hi Nani

12 bars are there my requirement is 6 bars should show green and another 6 bars should show yellow how can do

Re: barchart

jsingh71 — Fri, 14 Mar 2014 09:40:23 GMT

hi,

Go to chart properties the Expression Tab and expand + sign from your dimension and select background color.

After that put this expression:

if(FieldIndex('Month',Month)>6,Green(),Red())

It will solve your problem and you get output like

Re: barchart

Fri, 14 Mar 2014 09:41:10 GMT

Here 12 bars are there my requirement is 6 bars should show green and another 6 bars should show yellow how can do

Re: barchart

jsingh71 — Fri, 14 Mar 2014 09:43:46 GMT

I alredy told you, instead of Red() use Yellow().

Re: barchart

Fri, 14 Mar 2014 09:48:52 GMT

Thank You jsing

Its working

Re: barchart

jsingh71 — Fri, 14 Mar 2014 09:51:20 GMT

My pleasure......Happy Qliking.........

Re: barchart

veidlburkhard — Fri, 14 Mar 2014 10:03:02 GMT

Hi pn,

in order to achieve your goal please go to the 'Color' tab and check the 'Multicolored' checkbox. Then define the colors 1 to 6 with the same RGB namely red and the colors 7 to 12 with your second color e. g. green. That's it.

Hope, this helps

Burkhard