topic Re: Macros in QlikView in QlikView

Macros in QlikView

mahendragaur — Wed, 25 Nov 2020 16:16:04 GMT

Hello Experts,

I want to save straight table in .csv format at location "C:\ChartData.csv", ", ". I'm using below script but only getting msg "macro running" at bottom left corner and also my application is getting hang-

sub abc

set sObject = ActiveDocument.GetSheetObject("CH26")
sObject.Export "C:\ChartData.csv", ", "

end sub

Please let me know how can I save straight table at mentioned location.

Re: Macros in QlikView

hector_munoz — Mon, 27 Mar 2017 14:31:50 GMT

Hi Gaur,

I usde the following macro and it works fine:

Sub ExportToFile

set sObject = ActiveDocument.GetSheetObject("CH01")

sObject.Export "C:\TestFile.csv", ", "

End Sub

Ensure you are using the proper objetc ID and the path exists, and those things...

Regards,
H

Re: Macros in QlikView

krishnacbe — Mon, 27 Mar 2017 14:42:20 GMT

Limit the data in straight table and check the export and validate the paths.

As you are trying to save the file C Drive it might have some access issue, try different location.

Re: Macros in QlikView

mahendragaur — Tue, 28 Mar 2017 05:59:30 GMT

There is no access issues to save file in C drive and also in file there are only 850 rows and 5 columns but yeah no. of rows varies and it may be more than this. Also, when I'm using some other file with less data, it is getting updated successfully at the same location. So, my question is "Is there any other way to save the data or in some other format"?

Re: Macros in QlikView

mahendragaur — Tue, 28 Mar 2017 06:11:05 GMT

Hello Hector,

Everything is correct like Object ID, path and script as well. Any other suggestion apart from this will be helpful.

Thank you

Re: Macros in QlikView

hector_munoz — Tue, 28 Mar 2017 06:46:41 GMT

Cpuld you attach a (reduced) sample of your application?

Re: Macros in QlikView

mahendragaur — Tue, 28 Mar 2017 08:54:18 GMT

I can't attach the data here because it is the confidential data. Could you please let me know the other format in which I can save data of straight table.

Re: Macros in QlikView

Miguel_Angel_Baeyens — Tue, 28 Mar 2017 09:41:00 GMT

If it is an object what you want to save, check the API options for that (like Excel, PPT, etc.) to see which other formats are allowed.

If it is a table from the script, you can STORE into CSV files.

Re: Macros in QlikView

mahendragaur — Tue, 28 Mar 2017 09:47:41 GMT

I want to save whole data of straight table

Re: Macros in QlikView

Miguel_Angel_Baeyens — Tue, 28 Mar 2017 09:51:27 GMT

How big is that table and how much CPU and RAM resources do you have in the computer running the macro?

Re: Macros in QlikView

tamilarasu — Tue, 28 Mar 2017 09:58:18 GMT

Hello Mahendra,

Have a look at the attached file.

Re: Macros in QlikView

mahendragaur — Tue, 28 Mar 2017 10:02:08 GMT

file size is 85kb and RAM is 16 GB