topic Re: Export tables from Two sheets...Qlick View Macro in QlikView

Export tables from Two sheets...Qlick View Macro

pra_kale — Sun, 14 Jun 2015 09:56:02 GMT

Hi,

I am trying to export tables which I have created on Two sheets..currently only 4 tables are there only on one sheet i.e. summary sheet as per below given attachment, but this numbers may go up to 20 or 21 tables depending upon the requirement. Currently i am manually doing the activity of exporting in to excel..but this will become difficult if tables are 20 or 21.

Can any one help me with a Macro which will exports all the tables created on Two sheets, without any manual intervention, in excel on a mentioned path.

Screen shot of tables are attached..but in that currently I have given only 3 tables.

Thanks in Advance.

Re: Export tables from Two sheets...Qlick View Macro

marcus_sommer — Sun, 14 Jun 2015 10:48:39 GMT

There are many postings available to this topic here: see these as an example:

Loop Charts and Field Values - Excel Export Macro

Export Qlikview objects to multiple Excel sheet

- Marcus

Re: Export tables from Two sheets...Qlick View Macro

pra_kale — Sun, 14 Jun 2015 15:12:50 GMT

Thanks for your prompt reply.

I have copied the code written in the text file after SUB RunThroughChartsList and pasted under Macro edit module. I have included macro through setting--Document Properties--Triggers--OnPostReload.

But, when I executed the script post load Macro page only get's open and micro script is not get executed.

unable to understand the reason...can you pl help to resolve the issue.

Re: Export tables from Two sheets...Qlick View Macro

ecolomer — Sun, 14 Jun 2015 15:29:17 GMT

See this example.

Re: Export tables from Two sheets...Qlick View Macro

marcus_sommer — Sun, 14 Jun 2015 15:32:58 GMT

Have you checked if the macro itself runs? Press the button test within the left panel in the macro-editor and if there are an error you gets the line from error and on top from editor-window appeared a message.

- Marcus

Re: Export tables from Two sheets...Qlick View Macro

pra_kale — Sun, 14 Jun 2015 16:26:33 GMT

Thanks..

I am getting below given error..in below given line

Object required: 'f'

fname = f.GetContent.STRING

Re: Export tables from Two sheets...Qlick View Macro

marcus_sommer — Sun, 14 Jun 2015 16:37:49 GMT

The reason for this is mostly a missing "set":

set f = ...

and/or

set fname = f.GetContent.STRING

- Marcus

Re: Export tables from Two sheets...Qlick View Macro

pra_kale — Sun, 14 Jun 2015 16:48:47 GMT

Hi,

I have tried by both the way but still getting same error..

Object required: 'fname'

Re: Export tables from Two sheets...Qlick View Macro

marcus_sommer — Sun, 14 Jun 2015 17:15:08 GMT

You will need to post some more of your code.

- Marcus

Re: Export tables from Two sheets...Qlick View Macro

pra_kale — Wed, 17 Jun 2015 17:14:36 GMT

Thank You Very Much...

The Macro to Export To excel Multiple sheet is very useful...but i am facing one problem in it.

When i am using this Macro i am able to export only 3 Tables in to excel..Means this macro creates only 3 sheets with the table names. I actually want to export around 20 to 25 tables in a excel. but that time this macro fails.

I am not able to understand where i should make a change in a Macro which will export the more than 3 sheets as well.

Can you please help in this.

Thanks in advance.