topic Re: Straight Table into Crosstable via script in QlikView

Straight Table into Crosstable via script

Tue, 13 Dec 2011 19:08:29 GMT

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.

Re: Straight Table into Crosstable via script

vgutkovsky — Tue, 13 Dec 2011 20:51:29 GMT

Why don't you just make it a pivot table? See attached. Or do you actually need it crosstabbed in the data?

Re: Straight Table into Crosstable via script

Tue, 13 Dec 2011 21:39:22 GMT

I actually store the data after loading/tranforming into a txt-file.

Re: Straight Table into Crosstable via script

vgutkovsky — Wed, 14 Dec 2011 03:09:19 GMT

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

Re: Straight Table into Crosstable via script

Sokkorn — Wed, 14 Dec 2011 06:34:38 GMT

Hi cplannerte,

Please check in my attahced file.

Let me know if you cannot open the file.

HTH

Regards,

Sokkorn Cheav

Re: Straight Table into Crosstable via script

Wed, 14 Dec 2011 08:40:26 GMT

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.

Re: Straight Table into Crosstable via script

Sokkorn — Wed, 14 Dec 2011 08:43:48 GMT

Hi cplannerte,

Go ahear and let me know.

Regards,

Sokkorn Cheav