Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a straight table and I need a crosstable. It is possible to 'turn' a straight table into a crosstable via script?
Enclosed you will see an application, Table 1 is the start and as a result I need Table2.
There is a wizard for loading crosstables while turning them into straight table but how it is possible vice versa?
Thanks in advanced.
Why don't you just make it a pivot table? See attached. Or do you actually need it crosstabbed in the data?
I actually store the data after loading/tranforming into a txt-file.
See this thread: http://community.qlik.com/thread/23968. You actually need the opposite of a crosstable. This can get a little tricky and, honestly, Excel handles it a lot better than QV so you might want to consider formatting the output elsewhere.
Regards,
Vlad
Hi cplannerte,
Please check in my attahced file.
Let me know if you cannot open the file.
HTH
Regards,
Sokkorn Cheav
Hi Sokkorn Cheav, I will try it, thank you.
I can't use Excel because of the amount of data, more than 1-2 million rows.
Hi cplannerte,
Go ahear and let me know.
Regards,
Sokkorn Cheav