topic Re: Re: Transpose a physical table in QlikView

Transpose a physical table

Fri, 20 Dec 2013 10:00:05 GMT

Hi All,

I have a physical table with the following structure:

ID_CLIENT Date Cost1 Cost2 Cost3 Cost4

1 20/12/2013 2 3 1 1

2 20/12/2013 1 1 1 1

I want to transpose in this table in qlikview:

ID_Client Date cost Amount

1 20/12/2013 Cost1 2

1 20/12/2013 Cost2 3

1 20/12/2013 Cost3 1

1 20/12/2013 Cost4 1

2 20/12/2013 Cost1 1

2 20/12/2013 Cost2 1

2 20/12/2013 Cost3 1

2 20/12/2013 Cost4 1

How should I go about it?

Thanks,

Peter_Cammaert — Fri, 20 Dec 2013 10:06:27 GMT

Use a LOAD prefix called CROSSTABLE. Very powerful. There is a wizard for this in the Script Editor. See QlikView help for further information.

Peter

tresB — Fri, 20 Dec 2013 10:10:50 GMT

Try like:

Crosstable( Cost, Amount, 2) Load * From <>;

Peter_Cammaert — Fri, 20 Dec 2013 10:11:52 GMT

See this document

Peter

jagan — Fri, 20 Dec 2013 10:13:12 GMT

Hi,

Try this script using Crosstable()

Data:

CrossTable(CostNo, Cost, 2)

LOAD * INLINE [

ID_CLIENT, Date, Cost1, Cost2, Cost3, Cost4

1, 20/12/2013, 2, 3, 1, 1

2, 20/12/2013 , 1, 1, 1, 1

];

Regards,

Jagan.

Fri, 20 Dec 2013 10:44:19 GMT

Thanks!