topic Excel automatic extrapolation in QlikView

Excel automatic extrapolation

danosoft — Mon, 29 Jul 2019 13:32:32 GMT

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

Re: Excel automatic extrapolation

dplr-rn — Mon, 29 Jul 2019 13:58:16 GMT

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

Re: Excel automatic extrapolation

danosoft — Mon, 29 Jul 2019 14:48:40 GMT

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

Re: Excel automatic extrapolation

dplr-rn — Mon, 29 Jul 2019 14:54:44 GMT

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.

Re: Excel automatic extrapolation

beck_bakytbek — Mon, 29 Jul 2019 15:06:28 GMT

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