Excel automatic extrapolation

[danosoft]

Hi, i want every day my Qlikview table will be export in excel automatically, and will be save in a directory.

How can i do that?

Thanks

[dplr-rn]

Straightforward ways - you need nprinting or similar like CIA report manager.

Alternative ways - you can save as csv from script. or try experimenting with Macros

https://community.qlik.com/t5/QlikView-Documents/Useful-Qlikview-Macros/ta-p/1494530

[danosoft]

 Hi, thanks for reply, i haven't nprinting, can be ok saving with CSV, but i need before i save in CSV do some filter, like filter the table for current month and year

thanks

[dplr-rn]

ok.

You will need to resident load the data into a temp table with where clause you want year month etc.  (make sure you set no concatenate )

then 

STORE MyTempTable INTO ..\Ouptut\MyCSVFile.csv (txt);

delete temp table. 

[beck_bakytbek]

D_caprelli,

look at this:

http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/

i hope that helps or you can extend your knowledge by that