Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Can I create an Excel file that exports out to a folder in the Qlikview script?

I couln't find any information on creating an excel file and exporting that file to a specific folder monthly. Can some send me the sntax that is used to do this, I'm assuming this is a popular demand but again I couldn't find anything on the community.

12 Replies
Anonymous
Not applicable
Author

i tried to create this kind of export in one of sample apps

and took a manual reload it doesn't though out the file

I think on post reload trigger doesn't get trigger with manual reload

try to do the reload on server.

you can create a button or text object and add action of export you are looking for and on clicking button/text object

it will export the data accordingly.

Anonymous
Not applicable
Author

Can I not use ONPOSTRELOAD in the triggers? Looking to export specific columns. I've tried the Store function but I get a lot of unnecessary data, such as my query.

Anonymous
Not applicable
Author

Test:

load

 
[cs] as 1

      ,
as 2

      ,
[tet] as 3

Resident Test;;

 
STORE export into

  (
txt, delimiter is ',');

 
drop Table export

This will only work in server mode.