topic Re: Depivot data (aka turn dimension names into data) in QlikView

Depivot data (aka turn dimension names into data)

justin_morley — Mon, 11 Nov 2013 12:27:51 GMT

Hi all,

Is there any native function in QlikView that allows depivoting, by which I mean take multiple different dimension names and express them as data. Here is an example of what I mean. I want to transform my data from this:

Category	dimension1	dimension2	dimension3
A	12	34123	23
B	423	12	64
C	534	23	21

to this:

Category	ThingType	ThingValue
A	dimension1	12
A	dimension2	34123
A	dimension3	23
B	dimension1	423
B	dimension2	12
B	dimension3	64
C	dimension1	534
C	dimension2	23
C	dimension3	21

You can see here that the dimension names dimension1-3 become data and two new dimensions are created, changing the data from "short and fat" to "long and skinny".

Ideally I'd like to do this in script.

Thanks in advance,

Justin

Re: Depivot data (aka turn dimension names into data)

kaushiknsolanki — Mon, 11 Nov 2013 12:32:21 GMT

Hi Justin,

Look for the function named "CrossTab".

Here are some useful links.

http://community.qlik.com/message/183117#183117

Regards,

Kaushik Solanki

Re: Depivot data (aka turn dimension names into data)

justin_morley — Mon, 11 Nov 2013 12:43:07 GMT

Yep, that worked a treat, thanks!

This problem is slightly more complicated, as I don't want to depivot *all* the dimensions, but I've enough to get going now.

Thanks for your help.

Justin

Re: Depivot data (aka turn dimension names into data)

kaushiknsolanki — Mon, 11 Nov 2013 12:44:24 GMT

Sure,

Keep going, if you get stuck, community is der.

Regards,

Kaushik Solanki