topic Re: How to open a QVW file as another user in QlikView

How to open a QVW file as another user

Thu, 27 Sep 2012 14:51:30 GMT

I have this QVW file that uses authentication from an excel document.

When I open the QVW it checks my windows user/pass to allow me access to the file. This particular file, I have access to but not a complete (for example, I can't reload this file). I do have an admin user/pass that I can use, but the file doesn't prompt me for the user/pass.

Is it possable to open a QVW file as another user, so the QVW would prompt me for a user/password?

P.S. I know that I could edit the authentication in the Excel document (I have access to it), but that fails the purpose since the QVW would have to be reloaded (and I can't reload) anyway for the updated Excel to be included.

Regards,

Gunnar

Re: How to open a QVW file as another user

kamalqlik — Thu, 27 Sep 2012 15:01:10 GMT

Hi Friend ,

in case you are having admin rights .

than log on with that admin username and password

Go to Document Properties tab->Security->and check the checkbox named as reload .

and save the document and open it again.

Hope it helps

regards

Kamal

Re: How to open a QVW file as another user

Thu, 27 Sep 2012 15:08:38 GMT

Hi Kamal

I would have admin rights if I could get the QVW to prompt me for user/pass.

However, as my current user, I open the security settings and the "reload" option is already checked, as well as "allow user reload" option.

Regards,

Gunnar

Re: How to open a QVW file as another user

kamalqlik — Thu, 27 Sep 2012 15:16:40 GMT

Hi,

Can u do one more thing.Go to Document Properties->Go to the Opening tab->Uncheck Initial data reduction based on section access .

Hope it help.

Dont forget to save and then open the application.

You can also see if User Properties->"Remember login credential until qlikview exists " is checked in General tab

regards

Kamal

Re: How to open a QVW file as another user

Thu, 27 Sep 2012 15:28:41 GMT

Hi Kamal

Thanks for the suggestion. I took the "initial data reduction based on section access" check off, saved, reopened the QVW, reloaded... but it gave me the same error:

ADMIN access required:

Section access

As before, I could get the admin access if the QVW would prompt me for the user/pass. But i'm at my wits end here

Regards,

Gunnar

Re: How to open a QVW file as another user

kamalqlik — Thu, 27 Sep 2012 15:35:59 GMT

Hi,

While you are on the application....can you go to the script .Comment the section access part from the script.

Save it is as a new document.

Than make the changes what you want.

regards

Kamal

Re: How to open a QVW file as another user

Thu, 27 Sep 2012 15:51:11 GMT

Hi Kamel

Alas, to no avail.

Saving as another QVW file does not "overwrite" the authentication access in the script, even if it's commented out.

Regards,

Gunnar

Re: How to open a QVW file as another user

Mon, 08 Oct 2012 10:09:13 GMT

With the help of Kamel, I have tried the following steps:

Went to 'Document Properties' -> 'Security' -> Checked the 'Reload' box -> Saved, closed and reopened the QVW.
Went to 'Document Properties' -> 'Opening Tab' -> Uncheked the 'Initial Data Reduction Based on Section Access' option -> Saved, closed and reopened the QVW.
Commented out the section access part from the script -> Saved the changes as a new QVW and reopened it.

The orginal problem has yet to be resolved. I'm still getting the 'ADMIN access required; Section Access' error when I try to reload the QVW. Any additional ideas are most welcome.

Regards,

Gunnar

Re: How to open a QVW file as another user

Tue, 30 Oct 2012 09:26:58 GMT

The orginal problem is unresolved. I'm open for any new suggestions. I have tried everything that has already been posted above.

Regards,

Gunnar