topic Re: Restricting Access to your dashboard in QlikView

Restricting Access to your dashboard

andyquirin — Mon, 26 Jan 2026 18:19:17 GMT

Hey QV Community,

I've got a dashboard containing sensitive data I don't want certain people to be able to access.

The list is of ~1000 users and is contained in an excel spreadsheet currently and contains their usernames and SSOs and titles.

Is there a way to check the user's title for a keyword to see if they should have access to a dashboard?

I want to use the title rather than the people's user names or SSOs because the list will be dynamic as people quit or get hired.

What is the best way to lock it down to a specific group?

Thanks,

Andy

iktrayanov — Fri, 17 Jan 2014 23:55:15 GMT

Are you using publisher?

Sat, 18 Jan 2014 01:21:07 GMT

Hi Andy, We can do this with help of section Access.

Firstly, you need to create the Security QVD with help of excel file.

Security:

LOAD UPPER(USERNAME) AS NTNAME ,

'USER' AS ACCESS

LOAD * FROM EXCEL_FILE

Where KEY_WORD = 'Active' ; (This place you need to provide the logic)

Concatenate(Security)

LOAD * INLINE [

NTNAME , ACCESS

QVSERVICEACCOUNT , ADMIN

];

STORE Security into Security.qvd (qvd) ;

Use this Security QVD in the section Table in the main application.

-----------------------

Section Access ;

LOAD NTNAME , ACCESS FROM Security.qvd (qvd) where 1=1 ;

Section Application ;

Please check the Initial Data Reduction Based on Section Access option in Document Properties --> Opening Tab

maxgro — Sat, 18 Jan 2014 17:54:58 GMT

Old but always very interesting doc about section access

Hope it helps you