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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

VBS Getgraphs function

Hi,

I was trying to loop through all graphs on a sheet. I know tables and graphs are named with same prefix "CHXXXX" hence assumed getgraphs function would also apply to tables however it doesn't. What function should I use to get to tables?

Cheers

Dan

3 Replies
Tyler_Waterfall
Employee
Employee

I'm not familiar with that VBS function, but Tables are TB...

Keep in mind that the chart ID can be changed to some other text string.

Tyler_Waterfall
Employee
Employee

If you just want a list of all the charts and objects by Id, consider scanning all the qvws of interest using the Governance Dashboard.http://market.qlik.com/qlikview-governance-dashboard.html

Not applicable
Author

Actually I just use default object ID so a pivot table is originally named as "CH1094" etc. I can probably use getsheetobjects() but assuming this will have unwanted items such as textbox, listbox etc.