Accessing Data Model / Table from Macro

Fri, 07 Nov 2014 18:11:14 GMT

Hi folks,

I am quite new to QlikView. I am trying to create a Co-relation matrix (pivot table). The structure is something like this

Variables Value A Value B Value C

Value A 1 0.3 0

Value B .48 1 -.25

Value C 0 .8 1

This might change with each reload (Number of Values may increase or decrease) which will happen once a month.

I am trying to write a Macro where in I will access the underlying qlikview table to have this structure created dynamically.

Public Sub CreateDynamicPivot()
Set Pivot = ActiveDocument.Sheets("Linear Regression").CreatePivotTable
Pivot.AddDimension "Variable"

' Trying to loop throug the table to AddExpression based on the table structure
   Pivot.AddExpression "Value A"
   Pivot.AddExpression "Value B"
   Pivot.AddExpression "Value B"

End Sub

Please help out with the best way to achieve this.

Thanks,

Vinay

topic Accessing Data Model / Table from Macro in QlikView

Accessing Data Model / Table from Macro