topic Re: Macro to export Script Module and Table Viewer in QlikView

Macro to export Script Module and Table Viewer

Anonymous — Mon, 13 Apr 2015 11:32:45 GMT

Hi,

I'm developing a macro that allow me to export to text (.txt , word, etc.) all text inside Script Module (not hidden script, only visible) and export to image the table viewer of document (PNG, JPG, etc.)

I search on API guide and Qlik Community but I didn't found anything.

Does anybody know if it possible to do this with macro VBA? Can anybody help me?

Thanks in advance,

Daniel

Re: Macro to export Script Module and Table Viewer

SergeyMak — Mon, 13 Apr 2015 11:35:45 GMT

Hi Daniel,

Could you clarify your idea? Why do you need it?

Regards,

Sergey

Re: Macro to export Script Module and Table Viewer

Anonymous — Mon, 13 Apr 2015 11:42:22 GMT

Hi Sergey,

Thanks for your answer and attention.

I'm doing a macro to develop automatic documention of a QlikView project. So, the reason that I need this is to put this information in a text document. So, my question is:

Is there any way to export the script of QlikView document and image of data model (that I see in table viewer)? (with a function or another idea). I didn't find anything helpfhul in API Guide...

Thanks for your help.

Daniel

Re: Macro to export Script Module and Table Viewer

marcus_sommer — Mon, 13 Apr 2015 11:44:41 GMT

The script could be automatically exported but (AFAIK) the pictures from table viewer not. See here an example from APIGuide.qvw to access the script:

rem ** add new line to script **

set docprop = ActiveDocument.GetProperties

docprop.Script = docprop.Script & "Load * from abc.csv;"

ActiveDocument.SetProperties docprop

- Marcus

Re: Macro to export Script Module and Table Viewer

SergeyMak — Mon, 13 Apr 2015 12:18:35 GMT

Markus gave you an example.

Just in case whether it could be helpful QlikView App Documentation

Regards,

Sergey

Re: Macro to export Script Module and Table Viewer

Anonymous — Mon, 13 Apr 2015 12:28:15 GMT

Thanks for your answer Marcus!

I use this code to extract all script of my QlikView document to txt file:

vRutaETL = ActiveDocument.GetVariable("vRutaETL").GetContent().String

CONST ForWriting = 2

Set objFSO = CreateObject("Scripting.FileSystemObject")

Set ficheroTXT = objFSO.OpenTextFile (vRutaETL, ForWriting, True)

ficheroTXT.WriteLine(ActiveDocument.GetProperties.Script)

ficheroTXT.Close()

So, it's imposible to export an image of data model of my QlikView document?

Best regards,

Daniel

Re: Macro to export Script Module and Table Viewer

Anonymous — Mon, 13 Apr 2015 12:29:49 GMT

Thank you Sergey!

I don't know about this QlikView App Documentation. It's a good sample to learn how programar VBA in QlikView.

Re: Macro to export Script Module and Table Viewer

marcus_sommer — Mon, 13 Apr 2015 12:51:48 GMT

I believe there isn't any (documented) way to automate the export from the table viewer. The only documented access is the print settings:

set docprop = ActiveDocument.GetProperties

docprop.TableViewerPrintSettings.Landscape = true

ActiveDocument.SetProperties docprop

but maybe there is more - undocumented or there is something within the easter egg ...

- Marcus

Re: Macro to export Script Module and Table Viewer

shaikbakshu — Wed, 11 Jul 2018 09:02:06 GMT

Hi Marcus,

Could you please share any script/macro to automate 'Export Structure'(.Mappings file) in 'Internal Table View'.

Thanks,

Bakshu.

Re: Macro to export Script Module and Table Viewer

marcus_sommer — Wed, 11 Jul 2018 09:08:57 GMT

AFAIK this isn't possible.

- Marcus

Re: Macro to export Script Module and Table Viewer

shaikbakshu — Wed, 11 Jul 2018 10:55:31 GMT

Hi Marcus,

Thank you for your Quick Response, I have one more clarification of the above,

If it is any possible to write Macros/Script to Export "System Table" Object from New Sheet Object into Excel sheet or Text file.

Thanks,

Bakshu.

Re: Macro to export Script Module and Table Viewer

marcus_sommer — Wed, 11 Jul 2018 11:58:33 GMT

Here are various examples how objects could be exported to excel: https://community.qlik.com/search.jspa?q=excel+export&type=document

- Marcus

Re: Macro to export Script Module and Table Viewer

shaikbakshu — Wed, 11 Jul 2018 12:11:00 GMT

Hi Marcus,

Thank you for this,

In that link one Post is "Table Viewer Table Automatically generated and Export to Excel" it this "Northwest.qvw" application Macro was not shown,

could you please help me to write macros for this scenario.

Thanks,

Bakshu.

Re: Macro to export Script Module and Table Viewer

marcus_sommer — Wed, 11 Jul 2018 13:11:20 GMT

Here an appropriate example from the APIGuide.qvw to create such a table:

rem Create HLO system table on new sheet

set Sheet=ActiveDocument.CreateSheet

set Hlo=Sheet.CreatePivotTable

Hlo.AddDimension "$Field"

Hlo.AddDimension "$Table"

Hlo.AddExpression "Only([$Field])"

set Prop = Hlo.GetProperties

Prop.TableProperties.PivotAlwaysFullyExpanded=true

Prop.Dimensions(0).SortCriteria.SortByAscii=0

Prop.Dimensions(0).SortCriteria.SortByLoadOrder=1

Prop.Dimensions(1).SortCriteria.SortByAscii=0

Prop.Dimensions(1).SortCriteria.SortByLoadOrder=1

Prop.TableProperties.NumberOfLeftDimensions=1

Hlo.SetProperties Prop

For exporting them take a look within the various examples from the link above.

- Marcus

Re: Macro to export Script Module and Table Viewer

shaikbakshu — Thu, 12 Jul 2018 09:43:49 GMT

Hi Marcus,

Thanks a lot for shared Macro for generate .XL file.

It is very use full to me what I got requirement.

Could you please help me to some modifications on that Macro.

Actually my requirement is bellow.

So could you please help me to write macro for this .

Thanks,

Bakshu

$Field	$Table
EMPLOYEE_ID	EMPLOYEES
FIRST_NAME	EMPLOYEES
JOB_ID	EMPLOYEES
JOB_ID	JOB_HISTORY
SALARY	EMPLOYEES
DEPARTMENT_ID	EMPLOYEES
DEPARTMENT_ID	DEPARTMENTS
DEPARTMENT_NAME	DEPARTMENTS
LOCATION_ID	DEPARTMENTS
Employenumber	JOB_HISTORY
START_DATE	JOB_HISTORY

Re: Macro to export Script Module and Table Viewer

shaikbakshu — Thu, 12 Jul 2018 09:56:30 GMT

Hi Marcus,

Thanks a lot for shared Macro for generate .XL file.

It is very use full to me what I got requirement.

Could you please help me to some modifications on that Macro.

Actually my requirement is bellow.

So could you please help me to write macro for this .

$Field	$Table	EMPLOYEES	DEPARTMENTS	JOB_HISTORY
JOB_ID		JOB_ID	-	JOB_ID
DEPARTMENT_ID		DEPARTMENT_ID	DEPARTMENT_ID	-
EMPLOYEE_ID		EMPLOYEE_ID	-	-
FIRST_NAME		FIRST_NAME	-	-
LAST_NAME		LAST_NAME	-	-
EMAIL		EMAIL	-	-
PHONE_NUMBER		PHONE_NUMBER	-	-
HIRE_DATE		HIRE_DATE	-	-
SALARY		SALARY	-	-
COMMISSION_PCT		COMMISSION_PCT	-	-
MANAGER_ID		MANAGER_ID	-	-
DEPARTMENT_NAME		-	DEPARTMENT_NAME	-
Managernumber		-	Managernumber	-
LOCATION_ID		-	LOCATION_ID	-
Employenumber		-	-	Employenumber
START_DATE		-	-	START_DATE
END_DATE		-	-	END_DATE
Departmentnumber		-	-	Departmentnumber

Thanks,

Bakshu

Re: Macro to export Script Module and Table Viewer

marcus_sommer — Thu, 12 Jul 2018 10:48:06 GMT

For pivoting a table take a look on this : Re: Pivoting in macro

- Marcus

Re: Macro to export Script Module and Table Viewer

shaikbakshu — Tue, 17 Jul 2018 07:54:50 GMT

Hi Marcus,

Thank you for this post. It is very use full to me.

Thanks lot.

Thanks,

Bakshu.