Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik community,
I'm trying to connect Survey Data in order to analyze it by using Qlikview.
Currently my script is looking like this:
Directory;
LOAD respondent_id,
Q1,
Q2,
Q3,
Q4,
Q5
FROM
Testdata.xlsx
(ooxml, embedded labels, table is Responses2);
Directory;
LOAD respondent_id,
[Vul hier deb_key in:],
[Mag ik u telefonisch een aantal vragen over uw ervaring met Wiltec stellen?],
[Hoe lang bent u al klant bij ons?],
[Wat is uw algemene tevredenheid over Wiltec],
[Hoe waarschijnlijk is het dat u Wiltec aanbeveelt aan vrienden of collega's?]
FROM
Testdata.xlsx
(ooxml, embedded labels, table is [Demographic information]);
Directory;
LOAD QuestionID,
Categorie,
Vraag
FROM
Testdata.xlsx
(ooxml, embedded labels, table is [Question Metadata]);
I want to Pivot my Q1, Q2 etc. and rename it to QuestionID so i Can connect it to my Question Metadata.
But i have no idea how?
Thanks in advance!
Try to use crosstable like:
Directory; CrossTable(QuestionID, Data) LOAD respondent_id, Q1, Q2, Q3, Q4, Q5 FROM Testdata.xlsx (ooxml, embedded labels, table is Responses2);
Instead of using:
Directory;
LOAD respondent_id,
Q1,
Q2,
Q3,
Q4,
Q5
FROM
Testdata.xlsx
(ooxml, embedded labels, table is Responses2);
Try to use crosstable like:
Directory; CrossTable(QuestionID, Data) LOAD respondent_id, Q1, Q2, Q3, Q4, Q5 FROM Testdata.xlsx (ooxml, embedded labels, table is Responses2);
Instead of using:
Directory;
LOAD respondent_id,
Q1,
Q2,
Q3,
Q4,
Q5
FROM
Testdata.xlsx
(ooxml, embedded labels, table is Responses2);