topic Re: DashBoard Authorisation in QlikView

DashBoard Authorisation

waqasshah — Thu, 09 Nov 2017 11:08:14 GMT

Dear All,

I have developed a dashboard. I want to place it in a Live environment but I want only a specific user "Tom" can view it for testing. Please note Tom has a developer licence and few other staff members have also developer licenses but I want just Tom can view the dashboard not any one else. Can you please help.

Kind Regards

Waqas Shah

Re: DashBoard Authorisation

rubenmarin — Thu, 09 Nov 2017 11:11:03 GMT

Hi Waqas, you can limit access to the sheet using conditional show of the sheet properties, with a condition like:

Subfield(OsUser(), '\', 2)='Tom'

You can check the result in a text box to confirm the result of the expression.

Re: DashBoard Authorisation

waqasshah — Thu, 09 Nov 2017 11:13:02 GMT

Thanks but I have 20 sheets in dashboard. Cant we manage it at one place rather then doing in 20 places?

Re: DashBoard Authorisation

waqasshah — Thu, 09 Nov 2017 11:14:25 GMT

because I have already tried this function

=mixmatch(OSUser(),'Tom')

but it did not work.....

Re: DashBoard Authorisation

rubenmarin — Thu, 09 Nov 2017 11:19:24 GMT

Oh, you meant access to all the document, not only one sheet, this can be donde with Windows permission (folders or in the same document) or with section access.

Section Access

There is a wizard in script editor (Insert -> Section Acess->Inline) to create a simple section access, as an example:

Section Access;

LOAD * INLINE [

ACCESS, NTNAME

USER, Domain\Tom

];

In document properties -> on Open -> Reduce using section access. Add also your user or you will be blocked, make a copy of the document before using section acess.

Re: DashBoard Authorisation

shraddha_g — Thu, 09 Nov 2017 11:29:22 GMT

Qlikview or Qliksense?

Re: DashBoard Authorisation

waqasshah — Thu, 09 Nov 2017 11:34:27 GMT

Thanks I am near by there following is my code

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, USER, Domain\TOM
];
Section Application;

In document properties then I need to click on triggers ? then click on OnOpen option under Document Event Triggers option tab ?

Re: DashBoard Authorisation

waqasshah — Thu, 09 Nov 2017 11:34:41 GMT

Qlikview

Re: DashBoard Authorisation

rubenmarin — Thu, 09 Nov 2017 11:38:03 GMT

It's In document properties -> on Open -> Reduce using section access.

But be aware that documents suing section access can be blocked for everyone forever if something goes worng, make a backup of the file.

It's a good idea to add your own user, adnd 'domain' should be the current domain (if exists).

Re: DashBoard Authorisation

waqasshah — Thu, 09 Nov 2017 11:52:50 GMT

Thanks . I am using Qlikview version 11.20. I cant find the option u mentioned. When I click on Settings-- Document Properties. the attached screen appears. on Open option is not available

Re: DashBoard Authorisation

rubenmarin — Thu, 09 Nov 2017 11:56:23 GMT

It's in 'Opening' tab (I though it was 'On Open', mine is in spanish), not in 'Triggers'.

Hope you noted my warnings on blocking the document with section access.

Re: DashBoard Authorisation

waqasshah — Thu, 09 Nov 2017 12:03:55 GMT

Thanks for ur help this screen comes up... still ur option cant see....

Re: DashBoard Authorisation

rubenmarin — Thu, 09 Nov 2017 12:07:21 GMT

Disable 'Initial Selection...' and enable 'Initial Data reduction...'.

It will start working when you close and open the document again, if you have access it allow to open the document, if not shows a message telling that you can't access the document.

Re: DashBoard Authorisation

waqasshah — Thu, 09 Nov 2017 12:10:36 GMT

Thanks let me test

Re: DashBoard Authorisation

waqasshah — Thu, 09 Nov 2017 12:19:46 GMT

hmm still not working infect it wont allow any user to access it .. with the error message please review screenshot. I have also enable the option Strict Exclusion

Please review the code I placed in loading

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, USER, DOMAIN\Tom, Domian\Shah, Domian\Mike

];

Section Application;

Re: DashBoard Authorisation

rubenmarin — Thu, 09 Nov 2017 12:24:52 GMT

Needs to be in separated rows, like if it was a table

Section Access;

LOAD * INLINE [

ACCESS, NTNAME,

USER, DOMAIN\Tom,

USER, Domian\Shah

USER, Domian\Mike

];

Section Application;

Some says ‘domain’, and others ‘domian’, this needs to be the real domain\user of the user environment.

Also, with section Access usually is better to use upper case:

DOMAIN\TOM

DOMIAN\SHAH

Re: DashBoard Authorisation

waqasshah — Thu, 09 Nov 2017 12:32:46 GMT

Thanks but I think u missed the commas after USER, Domian\Shah?? so comma will always come after user and the n domain name ?

Section Access;

LOAD * INLINE [

ACCESS, NTNAME,

USER, DOMAIN\Tom,

USER, Domian\Shah

USER, Domian\Mike

];

Section Application;

Re: DashBoard Authorisation

rubenmarin — Thu, 09 Nov 2017 12:36:13 GMT

Last commas should be deleted, first row is fields names, separated by commas, nexts rows are values for each field, also separated by commas.:

Section Access;

LOAD * INLINE [

ACCESS, NTNAME

USER, DOMAIN\Tom

USER, Domian\Shah

USER, Domian\Mike

];

Section Application;

Re: DashBoard Authorisation

waqasshah — Thu, 09 Nov 2017 12:50:15 GMT

Many Thanks