topic Re: How to access directly to QLIKVIEW document in QlikView

How to access directly to QLIKVIEW document

Mon, 26 Jan 2026 18:19:17 GMT

Is it possible to access directly to QLIKVIEW document without retyping your username and password

using a web link ?

I have tried to use this link

<a href="http://SERVER/QvAJAXZfc/opendoc.htm?document=DOCUMENT.qvw&userid=USER&password=PASSWORD">qlikview document</a>

But it request me always user and password

Regards

Oronzo

How to access directly to QLIKVIEW document

Miguel_Angel_Baeyens — Tue, 17 Jan 2012 11:22:50 GMT

Hi Oronzo,

It seems that you are embedding from an external web page to the qlikview. If you use the Plugin, you can set up the browser to get your current logon credentials and pass them to the Server, you will need to use NTNAME in section access instead of USERID and PASSWORD.

I have tested with Firefox and works as well for the Ajax client. I have not tested that with Chrome, though.

Hope that helps.

Miguel

How to access directly to QLIKVIEW document

Tue, 17 Jan 2012 11:32:48 GMT

Thank you Miguel Angel,

could you give an example for Mozilla Firefox ?

I have tried to configure DMS mode in my QLIKVIEW server and I have configured 2 users because I don't have Active Directory. What I must to do in Section Access ?

Thanks

Oronzo

Re: How to access directly to QLIKVIEW document

Miguel_Angel_Baeyens — Tue, 17 Jan 2012 11:54:24 GMT

Hi Oronzo,

Section access can use USERID and PASSWORD or NTNAME field instead, so it takes credentials from the current user. The NTNAME field must match with the returning value of the function OSUser(). So first, create a new text object with the function

=OSUser()

And that will return your user in DMS or security directory when you see the file through AccessPoint. However, your user is likely to be different from this, in this case (if DMS users and security users do not match), you will be prompted any time, because the Server needs to know whether you are a valid user or not.

But say your users are CUSTOM\USER1 and CUSTOM\USER2, and that QlikView Server is running under the account LOCAL\QVADMIN. Section access should look like

SECTION ACCESS;
LOAD * INLINE [
ACCESS, NTNAME
ADMIN, LOCAL\QVADMIN
USER, CUSTOM\USER1
USER, CUSTOM\USER2
];
SECTION APPLICATION;

That will allow the application to show for those 3 users, and if CUSTOM\USER3 gets to the AccessPoint he will not see this file.

Hope that helps.

Miguel

Re: How to access directly to QLIKVIEW document

Tue, 17 Jan 2012 12:09:15 GMT

Thanks for your kindness,

I will try your resolution and I will send my feedback

Regards

Oronzo

Re: How to access directly to QLIKVIEW document

Tue, 17 Jan 2012 14:06:37 GMT

Hi Miguel Angel,

I have tried to insert in the load script the access section before the section application for a CUSTOM\USER1

SECTION ACCESS; LOAD * INLINE [ ACCESS, NTNAME USER, CUSTOM\USER1 ]; SECTION APPLICATION;

but it request me always USER and PASSWORD when I click on the link

<a href="http://SERVER/QvAJAXZfc/opendoc.htm?document=DOCUMENT.qvw&userid=USER&password=PASSWORD">qlikview document</a>

And I cannot modify the document with the client

Maybe I have forgotten to do something else?

Regards

Oronzo

Re: How to access directly to QLIKVIEW document

Miguel_Angel_Baeyens — Tue, 17 Jan 2012 14:18:57 GMT

Hi,

Do not use userid and password parameters in the URL. If "CUSTOM\USER1" is not the user returned by OSUser() you will be prompted anyway, because QlikView Server needs to authenticate the user. I'm running a document with very similar issues, and the following URL works fine, if I'm properly authenticated onto the computer (it does not prompt for credentials):

http://server:port/QvAJAXZfc/opendoc.htm?document=Document.qvw&ntname=CUSTOM\USER1

This is working for documents with and without section access, but again, in my case, OSUser() returns "CUSTOM\USER1".

Eventually, you might need to develop a single sign on solution that catches the credentials of the user assigning his or her corresponding DMS entry and passing it to the QlikView Server. It's something alien to QlikView, and I don't know if there are QlikView ready solutions out there.

Regards.

Miguel

Re: How to access directly to QLIKVIEW document

Tue, 17 Jan 2012 14:51:27 GMT

Miguel

If I put

OSUser()=

I find my username

PCOronzo/Oronzo

If I put the section Access I have failed authentication

SECTION ACCESS; LOAD * INLINE [ ACCESS, NTNAME ADMIN, LOCAL\QVADMIN USER, CUSTOM\USER1 ]; ....

Regards

Oronzo

Re: How to access directly to QLIKVIEW document

Miguel_Angel_Baeyens — Tue, 17 Jan 2012 14:57:49 GMT

Oronzo,

As far as I see, you will need to add a new line

USER, PCORONZO\ORONZO

to your section access. If not, you will not granted access, anyway.

Regards.

Miguel

Re: How to access directly to QLIKVIEW document

Tue, 17 Jan 2012 15:26:37 GMT

Hi Miguel,

I have put

USER, PCORONZO\ORONZO in the SECTION ACCESS

so now I can access to the document with the QLIKVIEW Personal Edition

but I can't access to the document with the user

CUSTOM\USER1 using the web link

http://server:port/QvAJAXZfc/opendoc.htm?document=Document.qvw&ntname=CUSTOM\USER1

Oronzo

Re: How to access directly to QLIKVIEW document

Miguel_Angel_Baeyens — Tue, 17 Jan 2012 15:47:47 GMT

Oronzo,

Is CUSTOM\USER1 the user you have in the custom directory? You are trying that URL with a user that, in spite of being in the section access, is not YOUR user. Did you try the OSUser() function as I mentioned above?

Miguel

How to access directly to QLIKVIEW document

Tue, 17 Jan 2012 15:59:55 GMT

Hi Miguel

CUSTOM\USER1 is user of CUSTOM directory

I have tried the function OSUser()

I'm trying to access to the link from my PCOronzo

http://server:port/QvAJAXZfc/opendoc.htm?document=Document.qvw&ntname=CUSTOM\USER1

Did I have to configure a Custom Directory PCOronzo with user

Oronzo ?

Regards

Oronzo

Re: How to access directly to QLIKVIEW document

Miguel_Angel_Baeyens — Tue, 17 Jan 2012 16:20:36 GMT

Did I have to configure a Custom Directory PCOronzo with user
Oronzo ?

Yes, I'd do that in just to test if all the above will work in your environment as well. Give permissions to that user on the document where section access with NTNAME is with that username.

Hope that helps.

Miguel

Re: How to access directly to QLIKVIEW document

Tue, 17 Jan 2012 16:30:05 GMT

Hi I will wait your test

my hostname is pc-oronzo

and my user is Oronzo

Regards