Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Partner
Partner

Compare block charts

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.

 

 

Labels (1)
4 Replies
MVP & Luminary
MVP & Luminary

Re: Compare block charts

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


talk is cheap, supply exceeds demand
chrismarlow
Valued Contributor

Re: Compare block charts

Hi,

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

20181218_1.png 

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

Cheers,

Chris.

chrismarlow
Valued Contributor

Re: Compare block charts

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;

20181218_2.png

20181218_3.pngCheers,

Chris.

MVP & Luminary
MVP & Luminary

Re: Compare block charts

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

-Rob