Managing user access on QlikView

[#1]

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

[#2]

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

[jagan]

Please find below link to implement this functionality

Sheet level access

Regards,

Jagan.

[#4]

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,

[maxgro]

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

[#6]

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

[#7]

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

[#8]

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