Discussion Board for collaboration related to Creating Analytics for QlikView.
i have written a following Macro Function
Set Sheet = ActiveDocument.GetSheetObject("CH01")
Rows = Sheet.GetNoOfRows
CountNumberOfRows = Rows
Now i m calling the above Macro Function in backend Like as below :
Let v = CountNumberOfRows();
But the variable v is not not getting any value.....
Go to Solution.
Just an example. You'll have to modify it to your needs yourself:
Objects = ActiveDocument.ActiveSheet.GetSheetObjectsFor i = lBound(Objects) To uBound(Objects) id = Objects(i).GetObjectId msgbox("ID = " & id)next
You can't access UI objects in the script, i.e. during reloads. So the macro can't get the number of rows.
thanks for the reply
Can you tell how to access the Sheetobjectid of the objects in each sheet.
I want the Id of the Charts in a sheet
You can access them with a macro like you posted. But the macro only works in the UI, in interactive mode. It won't work when you call the macro in the load script.
no..actually i want the id of the sheet objects in a particular sheet. for example if have 3 straight table in Sheet 1 then i want CH01,CH02,CH03
can i get the list of variables which i have created in variable Overview in macro