Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jplozano
Contributor
Contributor

Filter Data by User

Hi!.

We want to filter all data by the login user. I´m triying to use the QVUser() variable but it doesn´t write the name of the connected user.

How can i do this?

Thank u!

1 Solution

Accepted Solutions
Matthew_Grayndler

Hi Javier,

If the use case is that users should only be able to see their own data (and not anyone elses), then Section Access / Dynamic Data Reduction is the correct approach to apply row based security within Qlik Sense:

https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Scripting/Security/manage-securit...

If instead, you just wish to force a 'selection' when a user access the app, to put it into their context, then the user could either create a bookmark, or you could give them a link that uses the App Integration API to automatically select the relevent value when they access the link - ie:

http://servername/sense/app/{appid}/sheet/{sheetid}/state/analysis/select/{field}/{value1;value2}


Cheers

Matt

View solution in original post

4 Replies
isingh30
Specialist
Specialist

Did you try section access?

Thanks.

mikaelsc
Specialist
Specialist

be aware section access only works in an enterprise version of qlik (not desktop; not sure about cloud).

osuser() gives you the win user, but that's completely useless in qlik sense desktop

Matthew_Grayndler

Hi Javier,

If the use case is that users should only be able to see their own data (and not anyone elses), then Section Access / Dynamic Data Reduction is the correct approach to apply row based security within Qlik Sense:

https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Scripting/Security/manage-securit...

If instead, you just wish to force a 'selection' when a user access the app, to put it into their context, then the user could either create a bookmark, or you could give them a link that uses the App Integration API to automatically select the relevent value when they access the link - ie:

http://servername/sense/app/{appid}/sheet/{sheetid}/state/analysis/select/{field}/{value1;value2}


Cheers

Matt

jplozano
Contributor
Contributor
Author

Thank u very much!!