topic Horizontal dimension in QlikView

Horizontal dimension

Wed, 30 Jun 2010 17:36:55 GMT

Hi all,

is there an object which can work like the pivot chart in Excel does? I mean I want to add a vertical dimension, an horizontal dimension and then a expression which fills the cells with the proper numbers.

I could only find the Pivot table in which the dimensions can be only vertical.

Any suggestions please? Thanks a lot.

Horizontal dimension

Wed, 30 Jun 2010 17:55:51 GMT

Drag a dimension from row area and drop it on a top of the pivot table.

Horizontal dimension

Wed, 30 Jun 2010 17:56:43 GMT

In a PivotTable table you can drag and drop your dimensions to the vertical or horizontal, no problem. I do not understand what other features you need in this chart but I'll be glad to help. Please provide more details.

Horizontal dimension

Wed, 30 Jun 2010 18:07:15 GMT

Thanks to both of you 🙂 ! I didn't know of the drag and drop feature. Bye.

Re: Horizontal dimension

krishnaroopa — Wed, 26 Dec 2012 06:07:55 GMT

Great solution. I moved one of my dimension to horizontal and it works. We also need the totals at the end of each column and each row.

How we could achieve that? Please help