Discussion Board for collaboration on QlikView Scripting.
I have the following tables from a questionaire
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
keyquestion subject question
Q1 finance how .....?
Q2 finance how .....?
Q3 Human Resource how .....?
Q4 Human Resource how .....?
Q5 Service how .....?
Q6 service how .....? etc
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
You need to use Crosstable(). Try this in your script:
LOAD * FROM ResponsesData...;
LOAD * FROM QuestionsData...;
LOAD * FROM AnswersData...;
Hope this helps,
View solution in original post
Thanks Jason! The crossTable function works perfectly.