topic Excel file generation automatically in QlikView

Excel file generation automatically

vikasmahajan — Wed, 31 Aug 2011 05:07:59 GMT

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 ?

Excel file generation automatically

its_anandrjs — Wed, 31 Aug 2011 06:06:26 GMT

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

Excel file generation automatically

vikasmahajan — Wed, 31 Aug 2011 06:45:06 GMT

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