topic Re: excel file generation from qlikview and distribution in QlikView

excel file generation from qlikview and distribution

vikasmahajan — Mon, 05 Nov 2012 10:20:23 GMT

Dear All,

Does any one have macro to generate excel file automatically and will split into multiple files as

per dimensions and this excel files should be distribution should happen by mailing with conditions.

please help to achive the same.

Regards

Vikas

Re: excel file generation from qlikview and distribution

Mon, 05 Nov 2012 13:25:42 GMT

Hi,

I'm not sure if that will do all the tasks you mentioned, but I suggest you use the script syntax (assuming you have QV11) - notice the (txt) suffix, which enables you to export a comma delimited file, automatically from the script):

store your_table_in_the_script into your_csv_file.csv (txt);

Now, embed this syntax in a for loop, which will scan your_table_in_the_script few times, each time with a different value in the where clause.

Hope it helps,

Yigal

Re: excel file generation from qlikview and distribution

whiteline — Mon, 05 Nov 2012 14:54:03 GMT

Hi.

I think this search could help you a lot:

http://community.qlik.com/search.jspa?resultTypes=&dateRange=all&peopleEnabled=true&q=export+to+Excel+Macro&containerType=&container=&containerName=&username=&rankBy=relevance&numResults=15