Excel file generation automatically - Qlik Community

vikasmahajan · ‎2011-08-31

Dear All,

Can we generate report automatically in QV and throw in excel sheet ,

I have qv with screen short i want to geneate excel sheet for each hq report should generate in seferate excel sheets.

Can any body help me ?

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

its_anandrjs · ‎2011-08-31

Hi,

Yes it is possible you send individual objects send it to excel by creating a individual buttons for the objects and

put a code like this for the different buttons like

Add a button -> Actions -> Export -> Setup

Then seelct which fields which are associated with the your object and select the location of the excel file where you want to create it and give its location and excel file name in Export to option like D:\Main.xls.

Regards

Anand

vikasmahajan · ‎2011-08-31

I WANT TO CREATE AUTOMATIC EXCEL SHEET WITH ALL SELECTED DIMENSION VALUES OF HQ'S

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.