Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

georgina_spary
New Contributor II

Crosstable

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

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

I want to load it into this

StudentABDEFG
12311



12411


1
125

1
11
126

1
1
127

1
1
128


1

129


1

1301




131
1



...?

Tags (1)
6 Replies

Re: Crosstable

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 Smiley Frustratedtudent, Course

Expression : Count(Course)

HTH

Regards,

Anand

Not applicable

Re: Crosstable

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

georgina_spary
New Contributor II

Re: Crosstable

Hi Anand - I think I lost half your reply?

Highlighted
georgina_spary
New Contributor II

Re: Crosstable

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?

georgina_spary
New Contributor II

Re: Crosstable

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

Hi,

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

Regards,

Anand

Community Browser