crosstable reversed

[#1]

Hi

I have the following table:

Entity	Week	hour
A	1	32
A	2	34
A	3	28
A	4	49
B	1	12

Would like to convert (don't ask why) to a table with 53 columns (Entity + 52  weeks)

Entity	1	2	3	4	...
A	32	34	28	49
B	12

Is this possible witout reccursive joins...?

Dror

[#2]

Bingo! This exactly what i was looking for thanks!

Op 9 jun. 2013 06:09 schreef "Sokkorn Cheav (Cambodia)" <

qcwebmaster@qlik.com> het volgende:

**

QlikCommunity <http://community.qlik.com/index.jspa> Re:

crosstable reversed created by Sokkorn Cheav (Cambodia)<http://community.qlik.com/people/sokkorn.cheav>in

Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/354871#354871>

[Sokkorn]

Hi Dror,

Can you close this discussion?

Regards,Sokkorn