topic Re: Crosstable in QlikView

Crosstable

georgina_spary — Wed, 14 Nov 2012 11:45:18 GMT

I think this cross table should be easy but I can't get my head around it. My source data looks like this

Student	Course
123	A
123	B
124	A
124	B
124	G
125	D
125	F
125	G
126	D
126	F
127	D
127	F
128	E
129	E
130	A
131	B

I want to load it into this

Student	A	B	D	E	F	G
123	1	1
124	1	1				1
125			1		1	1
126			1		1
127			1		1
128				1
129				1
130	1
131		1

...?

Re: Crosstable

its_anandrjs — Wed, 14 Nov 2012 12:00:18 GMT

Hi,

There is no need of cross table creation you have to load your table with Student and Course and then after reloading create a pivot table

and on that take

Dimension :Student, Course

Expression : Count(Course)

HTH

Regards,

Anand

Re: Crosstable

Wed, 14 Nov 2012 12:01:27 GMT

Hi,

You can simply use the File Wizard while loading data from the source.

Use Enable Transformation Step -- Rotate tab and select Transpose to achieve the result.

Hope that help.

Regards,

-Khaled

Re: Crosstable

georgina_spary — Wed, 14 Nov 2012 12:01:34 GMT

Hi Anand - I think I lost half your reply?

Re: Crosstable

georgina_spary — Wed, 14 Nov 2012 12:02:58 GMT

Nice idea. but at the moment one of my fields is an applymap. I can change it of course. Both teh main load and the mapping load are from qvds but that should be OK?

Re: Crosstable

georgina_spary — Wed, 14 Nov 2012 12:04:48 GMT

Aha, got it. Yes that would be OK except I'm building a transformation table and will be doing a number of transformations on A,B, C, etc, so I was hoping to set up something tidy at teh early load stage.

Re: Crosstable

its_anandrjs — Wed, 14 Nov 2012 12:06:14 GMT

Hi,

Which fields but on your sample file structure looks good for the result that you want.

Regards,

Anand