topic Re: script to automatcally generate csv in QlikView

script to automatcally generate csv

rafael5958 — Sat, 16 Nov 2024 02:17:08 GMT

Hi, I have an app like in the example, what do I need is a macro/script so I can press a button and automatcally export a table in csv files by month-year. (01/2019, 02/2019, 03/2019.....).

Is it possible to do ?

Re: script to automatcally generate csv

NadiaB — Mon, 07 Oct 2019 19:43:02 GMT

Hi @rafael5958

Is there any specific reason that you want an extra button? You can use the "Export" option from the Access Point that will generate a CSV file for any object.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Export.htm

Kind regards.

Re: script to automatcally generate csv

rafael5958 — Mon, 07 Oct 2019 20:00:09 GMT

No, the button is optional, but I do need to run over all month and years and generate a cvs to each one. I got this so far, but its not working ....

sub aa set table = ActiveDocument.GetSheetObject( "CH01" ) for RowIter = 1 to table.GetRowCount-1 set cell = table.GetCell(RowIter,2) set sObject = ActiveDocument.GetSheetObject("TB01") sObject.Export "d:\"+table.GetCell(RowIter,0).text+"-"+table.GetCell(RowIter,1).text+".csv", ", " next end sub

Re: script to automatcally generate csv

NadiaB — Mon, 07 Oct 2019 20:06:26 GMT

Hi @rafael5958

It will be easier to create the object, you just need to create the appropriate expressions.

Re: script to automatcally generate csv

rafael5958 — Tue, 08 Oct 2019 01:04:30 GMT

Could give me a sample? I still didnt get it. lm not an experient qlikview user.

Re: script to automatcally generate csv

NadiaB — Tue, 08 Oct 2019 14:44:32 GMT

hi @rafael5958

Could you provide an example of the output you are trying to accomplish?

Thank you .

Re: script to automatcally generate csv

rafael5958 — Tue, 08 Oct 2019 14:52:43 GMT

got it on link below . Thanks.

https://community.qlik.com/t5/QlikView-App-Development/Looping-through-filter-values-and-saving-the-output-to-a-csv/td-p/1206264