How do you create a Questionnaire that a user can input answers to within Qlik?

RWilliams92 — Wed, 10 Jul 2019 13:45:10 GMT

I'm wanting to create a questionnaire, made up of 8 questions that is sent out to around 80 people, within Qlik. All of these are simple 'Yes or No' questions. I need to have these users select their answers, submit them and then I can gather their responses to report on in a table.

I understand I need to create variables for each of these in order to be able to store the answers? Something like the below as a start point (ScenarioDate being the timestamp):

'$(vNowNum)' as ScenarioDate,
'$(vQuestion1)' as Question1,
'$(vQuestion2)' as Question2,
'$(vQuestion3)' as Question3,
'$(vQuestion4)' as Question4,
'$(vQuestion5)' as Question5,
'$(vQuestion6)' as Question6,
'$(vQuestion7)' as Question7,
'$(vQuestion8)' as Question8
AutoGenerate(10);

How would I go about building this within the data loader? Thanks in advance

Ryan

Re: How do you create a Questionnaire that a user can input answers to within Qlik?

JordyWegman — Wed, 10 Jul 2019 14:29:27 GMT

Hi Ryan,

What you should do:

Create a widget with an iFrame
Set in this iFrame a Google Form
Get the Google Doc connector to connect https://www.youtube.com/watch?v=RalaPTmYBCM
Get a script where you load your Google Doc excel file every minute

Jordy

Climber

topic Re: How do you create a Questionnaire that a user can input answers to within Qlik? in App Development

How do you create a Questionnaire that a user can input answers to within Qlik?

Re: How do you create a Questionnaire that a user can input answers to within Qlik?