Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
andyquirin
New Contributor III

Restricting Access to your dashboard

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

3 Replies
iktrayanov
Contributor III

Re: Restricting Access to your dashboard

Are you using publisher?

Not applicable

Re: Restricting Access to your dashboard

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

MVP
MVP

Re: Restricting Access to your dashboard

Old but always very interesting doc about section access

Hope it helps you

Community Browser