topic Export Table in more file in QlikView

Export Table in more file

Thu, 13 Oct 2011 10:10:38 GMT

Hi to all,

i've a DataBase like the file EX_bank

I've this fields: Counrty (ONly 4 and no more), Bank, Euro €, city

I need to export the table in single file for each bank and each Country.

I've 2 possibilities:

Or create files with name example: Italy_Bank_1

Or Create 4 fixed folders (Italy, France, Spain,Usa - the countries are only this 4) and put inside the file with name bank1 etc...

Manually it's too long... i try to create a macro but i've problem to combination Country/Bank.

Can You Help me?

Thanks a lot!

Marco

Re: Export Table in more file

Thu, 13 Oct 2011 10:25:03 GMT

Hi. Try like this. Excel files stored in same folder where app.

Re: Export Table in more file

Thu, 13 Oct 2011 10:39:45 GMT

oh yeah I'm sorry. I forgot what you need in two dimensions.

Export Table in more file

Thu, 13 Oct 2011 12:56:18 GMT

Great!! You've solved my problem!!! Thank you Very Much!!

Can i ask you 2 question?

1 - Is it possibile to export table in the same file but in two o more different sheets? For ex File France and sheets for every bank?

2 - Is it possible to craate by macro folders (on Desktop) for each country and put inside different file for each bank of this country?

Is not urgent, but i think that in the future i need it...

Thank a lot for the macro of this morning!!!

Marco

Re: Export Table in more file

Thu, 13 Oct 2011 13:09:00 GMT

I am very pleased. It is possible. But now I have no time to help you. See the attachment. Probably come in handy.

Export Table in more file

Thu, 13 Oct 2011 14:56:37 GMT

Sorry Kostin,

in the macro there is a little problem.

If there are all banks for all countries no problem.

But if i haven't all banks for all countries the macro export also a files for the other banks but lost the selection for that country.

I don't know if you understand me... In your file look the export for USA.

There are only bank 1 and 2 in USA. But the macro export also the complete file for banks 3 and 4 (name USA_bank3) but inside is a report for the other countries...

Sorry and thank you for your answer.

Marco