topic Re: Extracting the table chart to excel in QlikView

Extracting the table chart to excel

Mon, 17 Nov 2014 17:48:50 GMT

Hi Frnds,

I want to export the table chart to excel which is size of 300 mb. I am doing this by button using macro. But our platform team have policy like u can't extract the file which is more than 32 mb so not geting approval from our platform team. But they are okay while reloading itself if we extract and save that file in shared path so tried with post reload option but in the qmc it will not work. So need your suggestion to resolve this issue.

Re: Extracting the table chart to excel

JonnyPoole — Mon, 17 Nov 2014 18:27:45 GMT

Its not the same thing but you can dump any table in the data model (not a UI chart) to TXT format (not excel) using the STORE command

store mytable into myfile.txt (txt);

Then the TXT is re(generated) every time the QVW executes.

Could that work or do you need those table chart functions ?

Re: Extracting the table chart to excel

Mon, 17 Nov 2014 18:53:06 GMT

Hi Jonathan,

Sorry i want to extract straight table and it has 20 expressions.

Regards,

sushil

Re: Re: Extracting the table chart to excel

ashfaq_haseeb — Tue, 18 Nov 2014 08:09:00 GMT

Hi,

I think this macro will do the job. It will store your table to qvd.

sub MyMacro
set obj = ActiveDocument.GetSheetObject("CH02")
obj.ExportEx "C:\test.qvd", 4 
end sub

Store in the path you like.

Let me know if that worked.

Regards

ASHFAQ

Re: Extracting the table chart to excel

Tue, 18 Nov 2014 09:03:35 GMT

Hi Ashfaq,

I want excel not qvd.

Regards,

sushil

Re: Extracting the table chart to excel

ashfaq_haseeb — Tue, 18 Nov 2014 09:15:58 GMT

try this

sub ExportExcel

set obj = ActiveDocument.GetSheetObject("CH02")

obj.ExportBiff "C:\test.xls"

end sub

Regards

ASHFAQ