Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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.