Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create Pivot Table in VB macro

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

13 Replies
Not applicable
Author

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

Thanks

ashfaq_haseeb
Champion III
Champion III

Hi,

In that case, look at the attached PDF.

Regards

ASHFAQ

Not applicable
Author

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

Thanks again

ashfaq_haseeb
Champion III
Champion III

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