excel file generation from qlikview and distribution

[vikasmahajan]

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

[#2]

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

[whiteline]

Hi.

I think this search could help you a lot:

http://community.qlik.com/search.jspa?resultTypes=&dateRange=all&peopleEnabled=true&q=export+to+Exce...