topic Re: issue of bar in QlikView

issue of bar

Thu, 05 Dec 2013 15:18:38 GMT

dear all,

One chart have three expressions, So each expressions show different bars. this is normal.

But i want first expression means first bar will show two colors like off of part red color and remaining part show to another color.

As Same as Below bar chart.Please help on this.

Thanks & Advance

Babu

Re: issue of bar

Gysbert_Wassenaar — Thu, 05 Dec 2013 15:37:35 GMT

Can you post a example with sample data?

Re: issue of bar

Fri, 06 Dec 2013 07:07:10 GMT

Post some example..how it is possible..have u made any changes.

Re: issue of bar

brijesh1991 — Fri, 06 Dec 2013 08:15:14 GMT

Go to chart properies---> Style---> Select SubType: Stacked

Re: issue of bar

Fri, 06 Dec 2013 08:40:22 GMT

when we select stacked,all the bars will appear in multi color,need only 1 bar as double color as shown in example by babu

Re: issue of bar

Thu, 12 Dec 2013 12:56:01 GMT

I'm interested in a solution for this, too

Re: issue of bar

Clever_Anjos — Thu, 12 Dec 2013 13:00:01 GMT

Are you always having 3 columns? This can be fixed?

Re: Re: issue of bar

Clever_Anjos — Thu, 12 Dec 2013 13:22:37 GMT

If you can fix the three columns, you can put 2 bar charts, side-by-side,

Maybe you´ll need to fix the min and max at Axes tab to assure bar height consistency

PFA the qvw

Re: issue of bar

Fri, 13 Dec 2013 03:56:56 GMT

Hey u are 2 intelligent,u mixed up the 2 separate bar charts...its not write....

i got a small logic,like if we apply an if condition

eg:if(value<3) then display green and (value>3) then blue....

This is an just an example,its not write,can u make it more clear...

Re: issue of bar

Clever_Anjos — Fri, 13 Dec 2013 18:48:43 GMT

I didnt understand you, what do you mean by 'it´s not write'?

Re: issue of bar

Sat, 14 Dec 2013 20:11:33 GMT

Setting the Style --> Stacked should work but as pointed out earlier it will make all bar charts stacked. You can avoid this happening, if you code the 3 bars as 3 different expressions.

Re: Re: issue of bar

qlikpahadi07 — Sun, 15 Dec 2013 05:28:09 GMT

Hi Kishori,

The only way to obtain this chart in my opinion too is what cleveranjos had mentioned with example. I don't think you will have an option like that if Stacked then; it will be applied to entire chart.

Else you can restrict your data as per your chart and change your Data Model but depends how ease it will be with your data model.

I am attaching a Simple Example where I have created few charts and changed my Data Model eg: Indicator Data changed to NEW INDICATOR and with same numbers.

Hope this will be helpful

Cheers!!!!

Re: Re: issue of bar

Tue, 17 Dec 2013 04:41:39 GMT

Thank u Guys....Its clear now

Re: issue of bar

qlikpahadi07 — Tue, 17 Dec 2013 07:18:54 GMT

Cheers!!! then every one deserve some points