Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

linking tables

Hi,

I have the following tables from a questionaire

table1

key     person      organisation     mail     Q1     Q2     Q3     Q4     Q5     Q6

01       xxx          xxxxx              xxx      0       1       2          1       2       1

02       xxx          xxxxx              xxx      1       2       1          3       2       1

03       xxx          xxxxx              xxx      1       0       3          1       0       0   etc

table2

keyquestion     subject                    question

Q1                  finance                     how .....?

Q2                  finance                     how .....?

Q3                  Human Resource      how .....?

Q4                  Human Resource      how .....?

Q5                  Service                     how .....?

Q6                  service                     how .....? etc

table3

answer           teXt

0                   bad

1                   average

2                   good

3                   perfect

Does anyone have an idea how to:

* connect the answers in table1 below Q1, Q2 etc to table3?

* connect the titles in table1 to table2?

I would like to make some graphs (for example) with a histogram of the scores for a single organisation and a specific subject. Anyone an idea? I can't find a similar question at this forum.

thanks in advance

1 Solution

Accepted Solutions
Jason_Michaelides
Luminary Alumni
Luminary Alumni

Hi,

You need to use Crosstable().  Try this in your script:

Responses:

Crosstable(keyquestion,answer,4)

LOAD * FROM ResponsesData...;

Questions:

LOAD * FROM QuestionsData...;

Answers:

LOAD * FROM AnswersData...;

Hope this helps,

Jason

View solution in original post

2 Replies
Jason_Michaelides
Luminary Alumni
Luminary Alumni

Hi,

You need to use Crosstable().  Try this in your script:

Responses:

Crosstable(keyquestion,answer,4)

LOAD * FROM ResponsesData...;

Questions:

LOAD * FROM QuestionsData...;

Answers:

LOAD * FROM AnswersData...;

Hope this helps,

Jason

Not applicable
Author

Thanks Jason! The crossTable function works perfectly.

greetz

Perry