topic Re: Exporting data from Straight table from front end to QVD or XLSX automatically via schedule in App Development

Exporting data from Straight table from front end to QVD or XLSX automatically via schedule

Krishnan92 — Fri, 02 Feb 2024 10:26:49 GMT

Hello,

I need to export data from my app's one of the straight table and store it via QVD or XLSX automaticalls instead of manual download. I know we can store data into QVDs in load script, but is there a way to export the data from front end app ?

Thanks!

Re: Exporting data from Straight table from front end to QVD or XLSX automatically via schedule

F_B — Fri, 02 Feb 2024 10:57:05 GMT

Hi Krishnan92,

there's this recent feature that is called Tabular Reporting which might be what you are looking for:

Tabular reporting with Qlik Cloud Analytics | Qlik Cloud Help

It alloows you to extract Excel files from your app. For what I know, there isn't a way to store QVD files from front end.

Bye

Re: Exporting data from Straight table from front end to QVD or XLSX automatically via schedule

Krishnan92 — Fri, 02 Feb 2024 10:59:31 GMT

Hi, thanks for your response. We dont have the Qlik cloud solution yet. We currently use the server version. Is there a way that I can achieve this with on prem version ?

Re: Exporting data from Straight table from front end to QVD or XLSX automatically via schedule

F_B — Fri, 02 Feb 2024 11:15:47 GMT

I'm sorry but I don't have experience with the on premise environment.

Hope you'll find the solution needed, bye

Re: Exporting data from Straight table from front end to QVD or XLSX automatically via schedule

dataexplorer — Fri, 02 Feb 2024 12:01:59 GMT

I doubt from the front end, if you are using the on prem env. Can you replicate those transformation in the load script using the Group By function, then store that table in a QVD or xlsx?