topic Re: Transpose and change title in QlikView

Transpose and change title

Thu, 25 Jul 2013 09:26:23 GMT

Hello Community,

I am new with qlikview and have a problem to transpose row contends in columns with a fixed title (SAP import).

Import from SAP:

should look like: scale and amount side by side, the number of scales could be different

i tried some reasons but never get the correct result.

Thank you, Norbert

ariel_klien — Thu, 25 Jul 2013 09:46:13 GMT

Hi,

Please See if the Attachment help you.

Ariel

Gysbert_Wassenaar — Thu, 25 Jul 2013 09:50:06 GMT

There's the easy way (recommended and ignoring the title labels) and the hard way (bad idea). See attached example.

Thu, 25 Jul 2013 09:53:05 GMT

Hi Ariel,

thanks for your fast Answer, but the import is from SAP with ca 350.000 lines and i have no field "NO" and no possibility to add it manually.

BR Norbert

ariel_klien — Thu, 25 Jul 2013 09:53:52 GMT

See how Gysbert create RowNo()....

Thu, 25 Jul 2013 11:05:54 GMT

It takes a little to load the data, but the result is perfect!!

Thanks a lot for your answers!!