topic Re: Compare block charts in QlikView

Compare block charts

martynlloyd — Sat, 16 Nov 2024 21:42:57 GMT

Hi,

I am using two Block Charts for a side by side comparison of market versus sales - how can I align the axis of each chart so that the block sizes are comparable?

Regards

Marty.

Re: Compare block charts

Gysbert_Wassenaar — Tue, 18 Dec 2018 13:58:01 GMT

Perhaps a bar chart will work better. Or perhaps you can use the Trellis option on the Dimensions tab.

Re: Compare block charts

chrismarlow — Tue, 18 Dec 2018 14:22:33 GMT

Hi,

Or maybe a grid chart (3 dimensions here, the minimum - 1 synthetic assuming your market & sales are in different fields);

Otherwise I think you are looking at macros to manipulate the size of the object.

Cheers,

Chris.

Re: Compare block charts

chrismarlow — Tue, 18 Dec 2018 19:13:51 GMT

Hi,

While putting off doing something I really ought to I took a look at the macro … so the attached manipulates the sizes of the objects. It does not take into account the white space, so you get a slightly distorted sizes, that could probably be fixed by tweaking the formulae, but the effect is Ok;

Cheers,

Chris.

Re: Compare block charts

rwunderlich — Tue, 18 Dec 2018 19:42:42 GMT

Perhaps use Market/Sales as the first dimension. That would render two blocks in the same chart with the same scale.

-Rob