topic Re: Creating Stacked Bar Chart in QlikView

Creating Stacked Bar Chart

Thu, 14 May 2015 08:54:47 GMT

Hi all,

I have a table which shows an overview of the different systems(system type, i.e. ERP system, Mail system, Sales system) implemented within a group of companies. The table looks like this.

I want to create a stacked bar chart. But I am facing some difficulties in creating a stacked bar chart which looks like this.

This is as far as I can get. The bars are categorised by the individual systems. rather than grouped by the family(ERP,Mail, Sales).

Is anyone able to advise me on what to do?

Thanks!

Re: Creating Stacked Bar Chart

Gysbert_Wassenaar — Thu, 14 May 2015 09:14:22 GMT

In the load script split that field into two fields, one for the family and one for the system. Use these two fields as dimensions in the bar chart.

Re: Creating Stacked Bar Chart

Thu, 14 May 2015 09:17:41 GMT

Thanks for the reply.

Is there any sample code around which I can possibly reference?

Re: Creating Stacked Bar Chart

Gysbert_Wassenaar — Thu, 14 May 2015 09:21:13 GMT

Very likely, but finding it could take a lot of time. Can you post an example source file?

Re: Creating Stacked Bar Chart

Thu, 14 May 2015 09:49:26 GMT

Here you go.

Thanks for your help.

Re: Creating Stacked Bar Chart

Gysbert_Wassenaar — Thu, 14 May 2015 09:59:26 GMT

See attached qvw.

Re: Creating Stacked Bar Chart

Fri, 15 May 2015 00:01:33 GMT

Hi Gysbert,

It does look like what I am trying to achieve on my app.

Let me try it on my actual data.

Thank you for your advice and being extremely helpful.