topic Re: Managing user access on QlikView in QlikView

Managing user access on QlikView

Mon, 28 Sep 2015 17:38:58 GMT

Hello eveyone,

I am new on QlikView, and I wonder if it is possible to set up user access permission for tabs within the same application.

The goal is to create a list of users who are allowed in certain tabs, and not at all as it is by default.

Thanks in advance,

Rodrigo

Re: Managing user access on QlikView

Mon, 28 Sep 2015 17:40:44 GMT

QlikView does have that functionality, and I have used successfully in the past. If it is a mater of restricting certain users to tabs, you can make the tab conditional, and have the condition be specific to the user

see example below

=UPPER(OSuser())='domain\user1'
OR UPPER(OSuser())='domain\user2'

This is the condition in the tab and will only be available, in this example for user 1 and 2

Re: Managing user access on QlikView

jagan — Mon, 28 Sep 2015 17:59:21 GMT

Please find below link to implement this functionality

Sheet level access

Regards,

Jagan.

Re: Managing user access on QlikView

Mon, 28 Sep 2015 18:14:36 GMT

Hi Jagan,

Thanks for your help!

I am a QlikView Personal Edition user, and i was not able to open the file that you sent.

I just can open files created by myself.

Is it possible to attach the script for this functionality in a txt ou doc file?

Thanks,

Re: Managing user access on QlikView

maxgro — Mon, 28 Sep 2015 18:32:39 GMT

script here, images in the attachment, and remember to backup your doc before using section access

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$ #,##0.00;$-#,##0.00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD.MM.YYYY';

SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';

SET MonthNames='ene;feb;mar;abr;may;jun;jul;ago;sep;oct;nov;dic';

SET DayNames='lun;mar;mié;jue;vie;sáb;dom';

Section Access;

LOAD * INLINE [

ACCESS, USERID

Admin, A

User, B

User, C

USer, D

];

Section Application;

SheetAccessMatrix:

LOAD upper([USERID]) as [USERID],

Sheet1,

Sheet2

FROM

sheetlevel.xlsx

(ooxml, embedded labels, table is Sheet1);

// excel file at the above link

Re: Managing user access on QlikView

Tue, 29 Sep 2015 13:07:34 GMT

Hi Adam,

Thanks for your tip.

Just for a better understanding, how QlikView will know which tab user 1 and 2 should be available?

For example, i want that user 1 and 2 see tab 1 and 2 (both), and user 3 and 4 see tab 3 and 4 (both).

How should i do that in the script?

Thanks,

Rodrigo

Re: Managing user access on QlikView

Tue, 29 Sep 2015 13:18:26 GMT

Rodrigo

In the sample I gave you, you can place the code in the condition of each tab, containing just the users you want to have access. It does not involve keeping up with another file, but keeping up with another file may make supporting it easier, depending on how often it changes

example

The code below would be the condition for tabs 1 and 2

=UPPER(OSuser())='domain\user1'
OR UPPER(OSuser())='domain\user2'

The code below would be the condition for tabs 3 and 4

=UPPER(OSuser())='domain\user3'
OR UPPER(OSuser())='domain\user4'

As you can see, the condition on each tab is specifying which users will have access - when they open up the application, they will only see the tabs they have access to

Re: Managing user access on QlikView

Mon, 16 Nov 2015 16:14:22 GMT

Hi guys,

Do you know how can i add a prompt to display a message to the user when has no access in some sheet?

For example, i have a main sheet with buttons to activate the sheets.

I would like to prompt a message when the user clicks in a button where he has no access.

My buttons are images.

Thanks