topic Re: Grouped chart with multiple dimensions in QlikView

Grouped chart with multiple dimensions

Wed, 21 May 2014 12:28:10 GMT

Hi,

I am trying to put together a simple bar chart with 3 or more dimensions, each time I do it it always makes it a stacked graph. Can anyone advise if this can be done? Within the style tab 'grouped' is marked but the graph is still stacked!

Thank you.

Re: Grouped chart with multiple dimensions

cfz — Wed, 21 May 2014 12:35:24 GMT

Hi Sara

From QlikView Reference Manual (page 641):

A maximum of two dimensions can be shown on the x-axis.

l A third dimension can be shown with multicolored stacked bars.

l Only table charts can display more than three dimensions.

l When two or more expressions are enabled, the two first dimensions are shown on

the x-axis and the expression with multicolored stacked bars.

I hope this answers your question.

Cheers,

Carlos

Re: Grouped chart with multiple dimensions

Gysbert_Wassenaar — Wed, 21 May 2014 12:36:11 GMT

What you're seeing is grouped and stacked. You can't use more than three dimensions in a bar chart. If you use more than one expression the maximum becomes two dimensions.

Re: Grouped chart with multiple dimensions

lironbaram — Wed, 21 May 2014 12:44:53 GMT

qlikview only support to dimensions in grouped mode

you can use a pivot table as a chart see attach example

the only thing it means your chart will always be vertical

look at the attachment