Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using VBA to open/access a .qvw file, but while opening the report through OpenDoc/OpenDocEx method it asks for User ID which is a part of section access implemented in the application. I am new to Qlikview and do not understand section access completely but I need to pass the value in the pop up displayed through a parameter in the script. Is it possible?
Below is the code sample in VBA
Dim QVApp As New QlikView.Application
Dim QVDoc As QlikView.Document
Dim strFilename As String
strFilename = "D:\QVReport.qvw"
Set QVDoc = QVApp.OpenDocEx(strFilename)
MsgBox QVDoc.NoOfSheets
I got the solution. There is a parameter called Username where we can pass the section access username.
I got the solution. There is a parameter called Username where we can pass the section access username.