Export Data from Qlik Sense

[oprilepin]

Hello everyone,

I'm new in Qlik Sense and have a task to export data from some Qlik Sense app into excel / csv file.

I have saw this video (https://www.youtube.com/watch?v=6d1Dw-CJK9M) about how to do it manually and it's clear for me, but my task is a bit changed that I should automate that process and would be great to use API for this but not UI automation with button clicking.

Could you please help me with that, share some info if that is possible to automate by API calls or maybe some additional solution you have?

Thank you!

[fosuzuki]

Hi,

You can use the STORE command in script editor. You may need to do some data transformations to create a table with the exact columns you need.

Another option is to use Qlik NPrinting to configure a report generation and distribution.

[oprilepin]

Hi Fosuzuki. Thank you for that solution, I will try that one, but I have additional question here.

Is it possible to use API call without any actions (configuration creation) on UI for Export data? Why Im asking about NOT USE UI, because when Im trying to do actions as on video from my previous message, then performance for load data on Qlik Sense page is not good and it takes me a time and also the same performance issue when I do some filtering on page to filter data by some rule. And here I think that by using only API call for Export data it will be more faster. Is it make sense and possible?

And, could you please add some example of using Qlik NPrinting and for the first solution you've provided? because Im new in that

Thank you!