topic grouped / stacked bar graph in QlikView

grouped / stacked bar graph

Wed, 11 Apr 2012 07:16:21 GMT

Hi All

I want to create a bar graph where part of the chart is grouped where the other parts is not. Is that possible?

In this example, I wanted to show the Tickets Created as one bar but I want to group / stack Closed and Canceled/Rejected into another bar so I end up with just bars and not 3.

Thanks

grouped / stacked bar graph

sivarajs — Wed, 11 Apr 2012 07:23:30 GMT

Go to expression tab and there is one button like Group thereyou can group your expression

Sivaraj S

Re: grouped / stacked bar graph

adhudson — Wed, 11 Apr 2012 07:35:26 GMT

Hi,

Please find the attached sample qvw.

Here, as per your requirement, tickets cancelled or rejected are grouped into one bar where tickets created is as another bar.

I have created a flag to differentiate between tickets created and tickets cancelled / rejected.

It has been used in as a secondary dimensionin the bar chart.

Hope this helps.

Regards

Andrew Hudson

Re: grouped / stacked bar graph

Thu, 12 Apr 2012 02:21:03 GMT

Thanks, that solved my question.

Re: grouped / stacked bar graph

Fri, 12 Sep 2014 09:55:31 GMT

There is a $syn table created because of two common fields (Date and Flag) between the two tables. Is it required to have two common fields? Because I tried with only one column...'Flag' it didn't work.

Re: Re: grouped / stacked bar graph

adhudson — Fri, 12 Sep 2014 11:33:59 GMT

Obviously, It is not mandatory to have synthetic table there. For the sake of simplicity/because of laziness, I have left it I think.

But you can also concatenate those two tables and make it into one. Given that inside this attachment.