topic Bar chart dimension in QlikView

Bar chart dimension

Wed, 25 Nov 2020 16:16:04 GMT

I have a bar chart plot between Product Type against Margin.

When I use dimension as Product and Expressions as Margin not work exactly as I expected as when I click on the bar it will drill down to a single bar.

So I replace margin as SUM({<[Product Type]=>} Margin), that way it resolve when select margin the bar chart will drill down to a single bar. However I am curious any other option I can use to avoid SUM here? As for my case Margin is not additive.

Re: Bar chart dimension

vinieme12 — Wed, 16 Nov 2016 15:04:25 GMT

It will be fine with SUM() as long as you do not have duplicate rows of data for the Margin

Re: Bar chart dimension

MarcoWedel — Wed, 16 Nov 2016 22:33:24 GMT

please provide some sample data and elaborate on your expected result.

thanks

Marco