Discussion Board for collaboration on QlikView Security and Governance.
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?
Are you using publisher?
Hi Andy, We can do this with help of section Access.
Firstly, you need to create the Security QVD with help of excel file.
LOAD UPPER(USERNAME) AS NTNAME ,
'USER' AS ACCESS
LOAD * FROM EXCEL_FILE
Where KEY_WORD = 'Active' ; (This place you need to provide the logic)
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
Old but always very interesting doc about section access
Hope it helps you