Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
Specialist II
Specialist II

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

Sivaraj S

Highlighted
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

Highlighted
Not applicable

Thanks, that solved my question.

Highlighted
Not applicable

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.

Highlighted
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.