Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

CrossTable, only getting distinct values

Hi,

I have a question regarding a CrossTable load :

Below is the query I have set up to collect the results...

But I only get the distinct answer values back when I try to present them!?

Surveys:

CrossTable(Question, Answer,3)

LOAD 

SchoolName,

Year,

classname,

[7915 Do you work ...?],

[7918 How many years ...?],

[7919 What is your first / native language?]

FROM

[..StaffSurveys.qvd]

(qvd);

fSurveys1:

LOAD

SchoolName,

Question,

Answer

Resident Surveys;

Drop table Surveys;


The result should look like this :

                               [7915 Do you work ...?]          [7918 How many years ...?]          [7919 What is your first / native language?]                   

School1                              YES                                             5                                             Swedish

School1                              YES                                                 6                                            Swedish

School1                              YES                                                 5                                             Swedish

School1                              NO                                                  5                                             English

School1                             NO                                                  4                                             English

School2                              YES                                                  2                                             English

School2                                NO                                                  2                                             English

School2                                NO                                                  3                                             English



Any ideas would be much appreciated!


Thanks in a bunch!


Calle