topic Export app data with code in QlikView

Export app data with code

maasool — Wed, 25 Nov 2020 16:16:04 GMT

Hello dear Qlik Community,

Is it possible to write into code, that table from one app will be stored on drive?
I would like to automate this 'right qlik on table --> export data' and store created table automatically on a drive for a user, who don't have access to QS.

Thanks,

maasool

Re: Export app data with code

cbushey1 — Tue, 21 May 2019 13:09:16 GMT

You could do this in the script by using the STORE command and writing the table out as excel, csv, txt. In order for this approach to work, all the fields you wish to export would need to live in the same table. You could always create a new table and applymap/join the fields you need to it, and then after the store command has run drop the table so it no longer exists in the script.

Re: Export app data with code

maasool — Tue, 21 May 2019 13:15:04 GMT

I already used this workaround, which you described. It does the work, as I need to export one simple table. Thanks for thinking along.