Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to build a bar chart by teams measuring avg days to complete as the overall bar length for tasks. Inside I am 3 color coded < 3 days (green), 3-30 days (yellow), > 3 days (red) that measure how many tasks fall within those timeframes. I ended up in google which told me that I needed the Vizlib Advanced bar or combo chart is that true or is there a way to build one or two measures that Qliks standard bar chart or combo chart can manipulate my needs? I do have access to Vizlib Combo Chart, but not he advanced version which I cannot find any information on. Any help is much appreciated.
If this standard bar chart or stacked/group?
You can use standard combo chart where every measure can have their own colour coding.
As per my understand, It could be a normal bar chart with color coding.
If you could provide some sample data and expected output, that would be great.
I loaded an example.
Here is an example, the values in the green, yellow, red values are total tasks and the overall blue is measuring total days to close.
You can visually do something like below:
This is done by making every expression a master expression and giving each of them a desired color. For the outline, you can use standart bar chart's styling setting as below:
But also, this only works if all expressions share common axis. E.g. all values between 0-100...
When you say this only works if all expressions share common axis. E.g. all values between 0-100... can the values be total tasks for 3 master measures and one be total days to close for the last master measure?
The issue with this example is, this measures are stacked, so if you want to show total tasks and total days that would be 2 axis and that means they can not be stacked. So for your question, unfortunately we can not do it this way. But maybe there is other ways that I don't know.