Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to rotate values into dimension with qlikview

Hello EveryBody ,

I would like to know how i can transform my values from lines to column with my script during a load statement. Let's look at this example :

I have this:

IDCodeValue
1A3
1B2
1C1
2D4

I would like to have this:

ID
A

B

C
D
1321
2


4

Thank you in advance,

Best Regards

1 Solution

Accepted Solutions
jeffmartins
Contributor II

Re: How to rotate values into dimension with qlikview

Hi laguerrethom,

I had the same problem and solved it with the code described in the attached file.

Regards 

3 Replies
Not applicable

Re: How to rotate values into dimension with qlikview

Hi,

have a look at using the transformation step on step 2 of the table wizard in load script.

Transformation Step -> Rotate -> Transpose

screenshot.2.jpg

screenshot.3.jpg

Regards

MC

jeffmartins
Contributor II

Re: How to rotate values into dimension with qlikview

Hi laguerrethom,

I had the same problem and solved it with the code described in the attached file.

Regards 

Not applicable

Re: How to rotate values into dimension with qlikview

Thank's a lot Jeffmartins,

it's roughly what I needed.