topic How can i crosstable this? in QlikView

How can i crosstable this?

amien — Fri, 30 Nov 2012 12:53:18 GMT

I have this:

5 dimensions

3 dimensions that are the starting point of the pivot

1 expression

Normally i would do a CROSSTABLE with 5. But now i have 3 dimensions that needed a CROSSTABLE. Is this possible? Do i need to CROSSTABLE this 3 times and then JOIN?

Re: How can i pivot this?

christian77 — Fri, 30 Nov 2012 14:05:37 GMT

Click and drag the column you want to move in you pivot table. Move it to the right, move it all the way up. You have one. Move the next up and place above the first one if you want it above or below otherwise. Then do the same for the 3rd one.

Good luck.

Re: How can i pivot this?

jonathandienst — Fri, 30 Nov 2012 14:13:02 GMT

Not sure what you are asking.

CROSSTABLE is used to "unpivot" a source data pivot table during load.

Pivoting in QV is done at the front end after loading (in which case the previous post explains what you need to do).

Regards

Jonathan

Re: How can i pivot this?

amien — Fri, 30 Nov 2012 14:17:00 GMT

Your right .. pivot is not correct. I changed to topic to crosstable.

perhaps to should create something to concatenate the 3 dimensions?

so in my excel i have:

5 dimensions on the left

3 dimensions on top

1 value in the middle

and i want to read this as a flat table.

Re: How can i pivot this?

jonathandienst — Fri, 30 Nov 2012 14:32:40 GMT

I was afraid you migh say that. The simplest solution to your problem is to get the file format changed. Of course that may not be possibe, but then it gets a lot more complex. What you will need to do is read the left and top dimension values (one at a time using data transformations) and have your script construct one or two hierarchies from these values. Then perform a normal CROSSTABLE load on the inner table, making sure that there are associations between the detail table and the hierarchies.

I suggest that you post a representative sample of the file if you would like someone to give you more specific assistance.

Regards

Jonathan

Re: How can i pivot this?

amien — Fri, 30 Nov 2012 14:46:07 GMT

i created an example excel file. top cells is what i have .. bottom cells is what i need