Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
koushikganapath
Contributor III

Exporting the variable values to a CSV/XLS file

I have this survey in my dashboard.

1.JPG

When the user selects Yes/No for a question and clicks Submit, the corresponding variables I created (For Example v1Yes and v1No for the 1st question) changes from 0 to 1. I also created a variable for calculating how many Yes/No will be recorded for each question.

Now, everytime a response is recorded, I need to export the response to an external file (CSV/XLS)

Now the survey has been done twice by two different users. The file should record responses something like this

QuestionYesNo
Do you think this tool is useful?01
Are you comfortable working on this tool?10
Do you think this tool is useful?10
Are you comfortable working on this tool?10

Is there a way to export the variables values like this?

3 Replies
MVP & Luminary
MVP & Luminary

Re: Exporting the variable values to a CSV/XLS file

Perhaps this blog post helps: Loading Data into Input Boxes


talk is cheap, supply exceeds demand
Partner
Partner

Re: Exporting the variable values to a CSV/XLS file

Hello Kaushik

Please find attached QVW, might be helpful for you.

Let me know if it is useful for you.

--

Regards,

Prashant P Baste

Not applicable

Re: Exporting the variable values to a CSV/XLS file

This is great Prashant!

Do you think there is a way were if the same user submit the survey twice, the second submission overwrites the first submission? I am taking the field 'User' to be the key field of the table, and thus has to be unqiue within that table.

Thanks again for this excellent QVW example