Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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_michaelid
Honored Contributor II

linking tables

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

2 Replies
jason_michaelid
Honored Contributor II

linking tables

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

linking tables

Thanks Jason! The crossTable function works perfectly.

greetz

Perry

Community Browser