topic Re: How to export the st table to excel based on the selections in QlikView

How to export the st table to excel based on the selections

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

Hi All,

i am having the following requirement.

when i click on the export button the following st table should be exported to excel with the each region data into one sheet.

per suppose emea region into one sheet, apj into another and ams into one another sheets.

here i am attaching the sample qvw.

below is the data

region	company name	supervisor	sales
ams	x	sony	245
apj	y	fim	255
emea	z	jen	265
apj	tcs	bin	450
apj	cts	fun	350
ams	bosch	sun	679
emea	lg	ram	789
ams	samsung	rama	532

I am new to macros kindly help me out wit this.

Re: How to export the st table to excel based on the selections

Frank_Hartmann — Mon, 11 Nov 2019 10:41:16 GMT

see attached qvw

hope this helps

Re: How to export the st table to excel based on the selections

Ramya — Mon, 11 Nov 2019 10:45:11 GMT

Hi Frank,

Thank you for the quick response .

but i need to get the export to excel. this thing i am unable to find in the qvw you shared.

can you help me out

Re: How to export the st table to excel based on the selections

Frank_Hartmann — Mon, 11 Nov 2019 11:04:15 GMT

if you press the "createExcelReport" Button within my uploaded qvw, then Excel is opening with the exported Tables, right?

Re: How to export the st table to excel based on the selections

Ramya — Mon, 11 Nov 2019 11:10:33 GMT

Hi Frank,

when i clicked on export to excel button it is opening the macro script instead of opening in the excel.

Re: How to export the st table to excel based on the selections

Frank_Hartmann — Mon, 11 Nov 2019 11:38:57 GMT

make sure that you have these settings activated inside Module and retry:

Re: How to export the st table to excel based on the selections

Ramya — Mon, 11 Nov 2019 11:56:50 GMT

Hi Frank,

Thank you so much for the help.

i need a small change instead of region 1 and region 2 and region 3 can we get the region names as emea ,ams ,apj as sheet names in the excel

Re: How to export the st table to excel based on the selections

Frank_Hartmann — Mon, 11 Nov 2019 12:28:56 GMT

see attached

hope this helps

Re: How to export the st table to excel based on the selections

Ramya — Mon, 11 Nov 2019 13:06:59 GMT

Hi Frank,

Thanks for all the help you provided.

i need one more help with all the inputs from you i had modified the code below attached .

right now we have hardocded for 2 subjects can you help me to make it dynamic for all the subjid without hardcoding

Your code is simple but here they are using the below code.

Kindly help me out to achieve this.

Thanks and Regards,

Ramya

Re: How to export the st table to excel based on the selections

Frank_Hartmann — Mon, 11 Nov 2019 13:12:39 GMT

see attached

Re: How to export the st table to excel based on the selections

Ramya — Mon, 11 Nov 2019 13:24:59 GMT

Hi Frank,

Thanks for your quick response.

is it possible to make my code dynamic, there are some formatting in it and also we have first sheet with name of report info and first cell with some text and second cell with another text like below

Study Name:	Subject Gram
Study Name:	Cohort 2




Event_CD	Event_Description
DTH	Death
tre	trew

Re: How to export the st table to excel based on the selections

Frank_Hartmann — Mon, 11 Nov 2019 15:06:04 GMT

see attached

Re: How to export the st table to excel based on the selections

Ramya — Tue, 12 Nov 2019 13:58:18 GMT

Hi Frank,

Thanks for the inputs.

i added the country dimension to my data and i tried to export the table with one country as one file

per suppose india into one excel and indonesia into another excel but it is not working .

Can you please help me to achieve this .

once again thanks for your patience and inputs.

Thanks and Regards,

Ramya

Re: How to export the st table to excel based on the selections

Frank_Hartmann — Tue, 12 Nov 2019 21:39:47 GMT

so you want to generate one excel file per country and every excelfile containing the tabs subjid (001-002,....)???

then see attached qvw and adapt the exportpath inside macro according your environment

hope this helps