Crosstable

[#1]

Hi guys,

I want to create a pivot table in QlikView that contains the dimensions "Product" and "Region" on a vertical axis and the dimension "Year" on a horizontal axis. I believe it´s called a crosstable but I wasn´t able to find it.

I attached a screenshot of how it is supposed to look in the end. I hope that explains what I want to do in a little more detail.

Thanks in advance for your help!

Lina

[MK_QSL]

It's a Pivot Table not cross table...

[alexandros17 · Accepted solution]

To realize what you want:

1) Create a Pivot table (Add sheet object -> Chart -> pivot table)

2) add the 3 columns you need as dimensions

3) add Sum(Price) as expression)

4) drag the year to the right top of the table (Until there is a horizontal line

Let me know

[rogerioqv]

Hello Lina ...

You can create yes, just do the crosstable of the table ... to do the load by using the button Script Files table, there is a part that you will choose to use the crosstable.

When you select the table to be loaded, use the "Enable Transformation Step" option, go two more times and have a screen where there is a button called crosstable.

Hugs!

[rogerioqv]

Sorry, I showed the steps to make a cross table ... you actually need is a pivot table ..

[#6]

Hi Alessandro,

thanks for the reply. It works.

Lina