Discussion Board for collaboration related to QlikView App Development.
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.
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.
View solution in original post
Go to expression tab and there is one button like Group thereyou can group your expression
Thanks, that solved my question.
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.
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.