Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

grouped / stacked bar graph

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?

Untitled.png

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

1 Solution

Accepted Solutions
adhudson
Creator II
Creator II

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

View solution in original post

5 Replies
sivarajs
Specialist II
Specialist II

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

Sivaraj S

adhudson
Creator II
Creator II

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

Not applicable
Author

Thanks, that solved my question.

Not applicable
Author

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.

adhudson
Creator II
Creator II

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.