topic Re: Exporting data into excel without macro using action in QlikView

Exporting data into excel without macro using action

Wed, 25 Nov 2020 16:16:04 GMT

Good morning

I need to automate the export data into EXCEL file some fields of a QVD file.

can we do this without using macros as triggers?

in the Modify script after the Load event of theQVD files which commands should I enter?

How to export data into excel through edit script commands while loading data into dashbord

thanks

felipedl — Thu, 28 Sep 2017 18:45:17 GMT

Hi Prasad,

You could store the data into a txt file, and the person would open it on Excel.

Something like:

Products:

Load * Inline

[

Client,Mapping Code

A, 1200

B, 20140

C, 01100

D, 32140

];

// Creates the Products.txt file, with the data separated by commas.

store Products into Products.txt (txt);

Felipe