topic Re: Create a tiered bar chart in QlikView

Create a tiered bar chart

peterderrington — Wed, 15 Jun 2022 15:06:25 GMT

I was wondering if anyone could help.

In the style tab of the chart properties box i was wanting to use the final option in the lefthand column of the 'Look' section:

I've got three expressions and one dimension and would like the layout that's shown in the icon rather than what shows in the 'Preview' box. eg, i'd like the blue bars at the back and then the red in front with the green ones right at the front.

Is it possible?

Re: Create a tiered bar chart

marcus_sommer — Wed, 15 Jun 2022 16:13:50 GMT

I think your used combination of dimensions and expressions didn't fit to this kind of chart-style. You may create a dummy-app with a few inline-records to play a bit with various dimensions-expression-combinations to create such style. After that you know how you would need to adjust your final chart and then deciding if you could change it appropriate respectively if it would be worth the needed efforts ...

- Marcus

Re: Create a tiered bar chart

MarcoWedel — Wed, 15 Jun 2022 22:35:24 GMT

You can convert your three expressions into one expression and an additional (second) synthetic dimension using something like this:

second dimension:

=ValueList('NameOfYourExpression1','NameOfYourExpression2','NameOfYourExpression3')

combined single expression:

=Pick(Match(ValueList('NameOfYourExpression1', 'NameOfYourExpression2', 'NameOfYourExpression3'), 'NameOfYourExpression1', 'NameOfYourExpression2', 'NameOfYourExpression3'),
<replace with your expression 1>,
<replace with your expression 2>,
<replace with your expression 3>

)

Re: Create a tiered bar chart

peterderrington — Wed, 22 Jun 2022 09:40:33 GMT

Thank you and huge apologies for the delay in coming back to you.

That has almost solved it. Although as you can see from the image theres clearly something i need to adjust:

What haven't i done?

Thanks,

Peter

Re: Create a tiered bar chart

marcus_sommer — Thu, 23 Jun 2022 11:38:09 GMT

It looked as if there is any TOTAL and/or any aggr() dimensionality within your expression not granular enough.

If you have applied the suggestion from Marco with the valuelist() you couldn't use this synthetic dimension within the aggr() or TOTAL. In this case you may move the logic into the script and creating the values with an inline-load as an island-table.

- Marcus

Re: Create a tiered bar chart

peterderrington — Mon, 27 Jun 2022 12:02:56 GMT

ok.....

(sorry, totally confused now lol)

So in my Dimensions I have 'Org' which would give the difference between the business units and then '=ValueList('Pocket QI','Leading for Improvement','Total')' which is based on the earlier responce.

My expressions are: