Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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?

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.

Highlighted

Re: Crosstable

Hi,

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

Regards,

Anand

Community Browser