Create Pivot Table in VB macro

[#1]

- Is it possible to create a Pivot Table from a VB macro ? I would like to have a macro (script created with Edit Module) to create a new QLikView pivot table in an existing document: select fields from the QLikView document, sort values, add fields and fill values for these new fields according to some rules.

- Could you hint at some example script to create QLikView object, in particular create a pivot Table ?

Thanks in advance.

[whiteline]

Hi.

Use the API Guide. There are simple examples of creating objects.

QlikView Core COM API Guide - Version 11

[#3]

thanks. i cnanot open. is there a pdf version ? thanks

[whiteline]

You have your own local copy of QV documentation somewhere:

C:\ProgramData\QlikTech\QlikView Documentation\Reference Manual

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

[#5]

there seems to be not much specific about creation of new sheet object in the help file. Could someone hint at a more precise documentation?

[whiteline]

You have structured API documentation with examples in APIguide.qvw

There is nothing more precise.

[#7]

Is there nothing more in the .qvw than the automation chapter in the Reference saved on disk in ProgramData?

[whiteline]

Yes. Object model definition and  VB code examples. Have you found the APIGuide.qvw ?

[#9]

I cannot access this document with PE.

[ashfaq_haseeb]

Hi,

If you have Qlikview Installed,

you can find the API guide in below path.

C:\ProgramData\QlikTech\QlikView Documentation\Automation\APIguide.qvw

Regards

ASHFAQ