Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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>
Hi Dror,
Can you close this discussion?
Regards,Sokkorn