topic Re: Crosstable in QlikView

Crosstable

Tue, 21 Oct 2014 14:09:48 GMT

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

Re: Crosstable

MK_QSL — Tue, 21 Oct 2014 14:14:08 GMT

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

Re: Crosstable

alexandros17 — Tue, 21 Oct 2014 14:15:32 GMT

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

Re: Crosstable

rogerioqv — Tue, 21 Oct 2014 14:17:43 GMT

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!

Re: Crosstable

rogerioqv — Tue, 21 Oct 2014 14:20:07 GMT

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

Re: Crosstable

Tue, 21 Oct 2014 14:28:59 GMT

Hi Alessandro,

thanks for the reply. It works.

Lina