Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to use an external parameter in my QVW to Show or Hide tabs depending on that parameter:
I am passing that parameter this way.
http://localhost/QvPlugin/opendoc.htm?document=qlikview/Setup_Viewer.qvw?Viewer=Lieu
The problem I have is that if I use that parameter in the 'Conditional' Show Sheet Box , it does not work.
When I display that variable in a text box , It is correct.
I tried to use a macro 'On open' That does :
==================================================
Sub StartApp
if Viewer = "Lieu" then
ActiveDocument.Sheets("Document\SH05").Activate
else
ActiveDocument.Sheets("Document\SH05").DeactivateAll
end if
end sub
===================================================
That does not work either.
Does someone has an idea on how I could do
Thanks for your help.
Philippe
I found the solution. In fact, I had a bad condition written in my sheet.
Hi Philippe,
I am trying to pass a parameter thru URL and based value I have to filter the data in QVW.
My URL is like this
http://qlikview.domain.com/QvPlugin/opendoc.htm?document=test%20Application.qvw&VarDealerId=10002
and the macro that I am calling is
Sub StartApp
myVal = ActiveDocument.Variables("VarDealerId").GetContent.String
ActiveDocument.Fields("DEALER_ID").Select myVal
msgbox myVal
end Sub.
Its not working. What I am doing wrong here. Can you please guide me.
Thanks
Hello,
The call sequence should be
http://qlikview.domain.com/QvPlugin/opendoc.htm?document=test%20Application.qvw?VarDealerId=10002
instead of
http://qlikview.domain.com/QvPlugin/opendoc.htm?document=test%20Application.qvw&VarDealerId=10002
Sign ? before the first parameter instead of &. The & separator should be use for the subsequent parameters.
Hope that helps !!!
Philippe
hi pergo,
did you managed to pass a parameter to a variable using the URL ? Can you post a sample app ?
Thank you.
Anthony
how can we do it in qlikview 9.. using access point.. whe i m using the ? method it says page cannot be displayed
Hello,
I am constructing the URL like this,
call sequence should be
http://localhost/QvPlugin/opendoc.htm?document=Dashboard.qvw.
But, this throws an error message that, the document failed to load as you don't have access to the document.
I am using QV9.0 SR2 with access point. Please, suggest as if this link works, then I will try to pass parameter to the document.
Regards,
Somnath.