Skip to main content
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.