Discussion Board for collaboration on QlikView Scripting.
I am trying to access QV sheet and its objects from Excel Macro. There are few sheets which are hidden and I want to show/access their properties. Let me know if anyone has successfully done it.
Friends, has anyone tried this or has a solution to this. I have been trying multiple things but no luck as of yet. Below is sample of few trial and error statements.
Dim QVApp As New QlikView.Application
Dim QVDoc As QlikView.Document
Dim QVSheet As SheetObject
Dim SP As Object
Dim strFilename As String
Dim i As Integer
strFilename = "D:\QVReport.qvw"
Set QVDoc = QVApp.OpenDocEx(strFilename, 1, False, "001")
Set QVSheet = QVDoc.GetSheetObjectByInternalCtlNo(5)
QVSheet.GetSheet.GetProperties.Show.Always = True
For i = 0 To QVDoc.NoOfSheets
why you use the Macro ?
Are you using QV Excel ?
Yes. VBA in Excel.
I am not familiar with QV Excel.
Create the New Tab Called "QV Excel" and Copy all the requires QV Charts into this sheet and Select Always on Layout tab. Use these objects into your QV Excel,