topic Re: Create Pivot Table in VB macro in QlikView

Create Pivot Table in VB macro

Sun, 22 Jun 2014 15:20:03 GMT

- 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.

Re: Create Pivot Table in VB macro

whiteline — Sun, 22 Jun 2014 17:16:31 GMT

Hi.

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

QlikView Core COM API Guide - Version 11

Re: Create Pivot Table in VB macro

Fri, 27 Jun 2014 09:27:48 GMT

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

Re: Create Pivot Table in VB macro

whiteline — Fri, 27 Jun 2014 09:48:56 GMT

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

Re: Create Pivot Table in VB macro

Fri, 27 Jun 2014 11:56:04 GMT

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?

Re: Create Pivot Table in VB macro

whiteline — Fri, 27 Jun 2014 12:50:06 GMT

You have structured API documentation with examples in APIguide.qvw

There is nothing more precise.

Re: Create Pivot Table in VB macro

Sat, 28 Jun 2014 20:59:56 GMT

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

Re: Create Pivot Table in VB macro

whiteline — Sun, 29 Jun 2014 12:35:46 GMT

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

Re: Create Pivot Table in VB macro

Sun, 29 Jun 2014 12:43:40 GMT

I cannot access this document with PE.

Re: Create Pivot Table in VB macro

ashfaq_haseeb — Sun, 29 Jun 2014 12:46:39 GMT

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

Re: Create Pivot Table in VB macro

Sun, 29 Jun 2014 12:47:51 GMT

not with the personal edition... at least there is nothing at this path...

Thanks

Re: Re: Create Pivot Table in VB macro

ashfaq_haseeb — Sun, 29 Jun 2014 12:53:02 GMT

Hi,

In that case, look at the attached PDF.

Regards

ASHFAQ

Re: Re: Create Pivot Table in VB macro

Sun, 29 Jun 2014 13:48:17 GMT

thanks a lot. Is there more in the API guide.qvw ? because the .pdf is quite light on the API description...

Thanks again

Re: Re: Create Pivot Table in VB macro

ashfaq_haseeb — Sun, 29 Jun 2014 13:55:27 GMT

Yes,

There is lot more in API.qvw.

I wonder have you come across this post

http://community.qlik.com/docs/DOC-2683

Regards

ASHFAQ