topic Re: need help in creating stacked bar in QlikView

need help in creating stacked bar

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I need one stacked bar chart like the one in the attachment and data is also there in

excel.could you help me with this.

thanks regard,

Anuradha

Re: need help in creating stacked bar

passionate — Wed, 18 Apr 2018 06:44:55 GMT

Please post some sample data

Re: need help in creating stacked bar

jubarrosor — Wed, 18 Apr 2018 07:17:30 GMT

Hello anuradha:

I used this chart sometimes but it's not certified by Qlik:

https://github.com/NielsLindberg/Qliksense.Extension.amWaterfall

Best Regards,

Juan P. Barroso

Re: need help in creating stacked bar

sudhakar0717 — Wed, 18 Apr 2018 07:39:30 GMT

you are creating this chart in qlik view or qlik sense.

Re: need help in creating stacked bar

Anonymous — Wed, 18 Apr 2018 10:51:20 GMT

in qlikview

Re: need help in creating stacked bar

Anonymous — Wed, 18 Apr 2018 11:47:19 GMT

data is like

product category month noofpatient

A win jan 80

A new jan 50

b win jan 50

b new jan 60

I want stacked chart to be product A with win as one dimension as shown in the image attached above.

regards,

Anuradha

Re: need help in creating stacked bar

vvira1316 — Wed, 18 Apr 2018 12:29:28 GMT

Hi,

You can use month (Month Year) as your first dimension and product/category as second dimension and noofpatient in your expression.

There is limited data in your sample and in doc it is a screen shot/image. Not seeing actual Excel.

You can use/reference sample from following discussion as per your need and data

Issue with stacking accumulation in bar chart

I hope it helps you.

Re: need help in creating stacked bar

jubarrosor — Wed, 18 Apr 2018 12:40:41 GMT

Like this?

Best Regards,

Juan P. Barroso

Re: need help in creating stacked bar

Anonymous — Thu, 19 Apr 2018 11:43:04 GMT

I am not able to attach the excel file .

Re: need help in creating stacked bar

vvira1316 — Thu, 19 Apr 2018 12:40:28 GMT

Have you checked Juan's solution?

you have to use advanced editor then you will see attach option at bottom.

Re: need help in creating stacked bar

Anonymous — Thu, 19 Apr 2018 13:05:52 GMT

HI Juan,

I am not able to open the qvd file

Re: need help in creating stacked bar

vvira1316 — Thu, 19 Apr 2018 13:11:34 GMT

probably it is in QV12 and you may be using QV11

Re: need help in creating stacked bar

jubarrosor — Thu, 19 Apr 2018 13:11:51 GMT

I'm using v11.20

Wath is the error?

Re: need help in creating stacked bar

Anonymous — Thu, 19 Apr 2018 13:15:52 GMT

Hi Vijay,

I have attached the excel file. the WO sheet is the raw data and sheet1 is the pivot table that I need to paste in PPT which now I am

trying to clone in qlikview

Regards,

Anuradha

Re: need help in creating stacked bar

jubarrosor — Thu, 19 Apr 2018 14:01:18 GMT

Something like this?

Best Regards,

Juan P. Barroso

Re: need help in creating stacked bar

Anonymous — Mon, 23 Apr 2018 08:14:09 GMT

Hi Juan,

I am not able to open ,getting this msg while opening.

the chart should be ike this only but ,I need ( bydureon with new with insulin) and (bydureon with new without insulin)

something like this.

hope it is clear.

Re: need help in creating stacked bar

vvira1316 — Mon, 23 Apr 2018 12:08:07 GMT

Hi,

It is coming because you are using QV personal edition. If you open the document using a license version QV then you should be able to see it. Also your need message in above is not clear. Hopefully you won't have to reach if you are able to open the document.

In order to open it please save it on your system and then use Open in Server from File Menu to use server you use for your license version of QV. After that it will allow you to access the file.

BR,

Vijay