Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Associating / Mapping Fields to Values using reference code list

Hi community,

I have a question about using mapping tables to create a data model to capture survey data. 

I'm working with 3 Excel files (examples below and excel doc attached). Basically I need to use these data and mappings to produce a chart that allows me to see the survey data with the text for both the question and answers by person/respondent and aggregate  the results by question.

I've done a lot of reading on mappings and have tried transposing the tables to have the columns match but I can't figure out how to actually link all 3 tables. The result file is giving me issues. Any help is GREATLY appreciated

Thanks!

1. Questions in survey with 2 columns Question_ID and Question_Text:

  

Question_IDQuestion_Text
1AAre you interested in receiving information on the following topics?
1A1Alcohol and other drug use
1A2Cold/Flu/Sore throat
1A3Stress
1A4Eating disorders
1A5Grief
1A6Injury prevention
1A7Nutrition
1A8Physical activity
2On how many of the past 7 days did you get enough sleep so that you felt rested when you woke up in the morning?
3What is your status?
4A1Have you ever:
4A2Felt things were hopeless
4A3Felt overwhelmed by all you had to do
4A4Felt exhausted (not from physical activity)
4A5Felt very lonely
4A6Felt very sad

2. Response Options with 3 columns -Question ID, Response Code, Response Text:


   

Question_IDQuestion_Response_Value_CodeQuestion_ResposeValue_Text
11No
12Yes
210 days
221 day
232 days
243 days
254 days
265 days
276 days
287 days
31Full-time
32Part-time
33Other
41No, never
42No, not in the last 12 months
43Yes, in the last 2 weeks
44Yes, in the last 30 days
45Yes, in the last 12 months





3. Response Options with 3 columns -Question ID, Response Code, Response Text:

Example of 15 survey responses (1 row per survey)


 

1A11A21A31A41A51A61A71A8234A14A24A34A44A54A6
2.002.002.002.002.002.002.001.006.001.004.004.004.004.004.004.00
1.001.001.002.002.002.002.001.008.001.004.004.001.001.001.001.00
1.001.001.001.001.001.001.001.008.001.001.001.001.001.001.001.00
2.002.002.002.002.002.002.002.004.001.003.005.002.002.002.005.00
2.002.002.002.002.002.002.002.006.001.003.003.004.004.004.005.00
2.002.001.002.002.001.002.002.003.001.005.005.005.005.002.005.00
2.002.002.002.002.002.002.002.005.001.003.003.003.003.003.004.00
2.002.001.002.002.002.001.002.004.001.003.003.002.003.003.003.00
1.001.001.001.001.001.001.001.008.001.004.004.004.004.004.004.00
1.001.001.001.001.001.001.001.003.001.003.003.003.004.005.003.00
1.001.001.001.001.001.001.001.003.001.002.002.002.002.001.001.00
1.001.001.001.001.001.001.001.001.001.003.003.003.003.003.003.00
2.002.002.002.002.001.001.001.004.002.004.002.001.001.001.004.00
1.002.002.002.002.001.001.002.001.001.003.003.003.003.003.003.00
1.002.001.002.002.002.002.001.005.001.005.005.001.001.001.005.00