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

Exporting the variable values to a CSV/XLS file

Anonymous — Mon, 15 Jun 2015 07:07:11 GMT

I have this survey in my dashboard.

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

Question	Yes	No
Do you think this tool is useful?	0	1
Are you comfortable working on this tool?	1	0
Do you think this tool is useful?	1	0
Are you comfortable working on this tool?	1	0

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

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

Gysbert_Wassenaar — Mon, 15 Jun 2015 07:37:28 GMT

Perhaps this blog post helps: Loading Data into Input Boxes

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

prashantbaste — Mon, 15 Jun 2015 13:17:34 GMT

Hello Kaushik

Please find attached QVW, might be helpful for you.

Let me know if it is useful for you.

Regards,

Prashant P Baste

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

Wed, 27 Jan 2016 10:33:38 GMT

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