Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jplozano
New 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!

Tags (1)
1 Solution

Accepted Solutions
Employee
Employee

Re: Filter Data by User

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

4 Replies
isingh30
Contributor III

Re: Filter Data by User

Did you try section access?

Thanks.

mikaelsc
Contributor III

Re: Filter Data by User

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

Employee
Employee

Re: Filter Data by User

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
New Contributor

Re: Filter Data by User

Thank u very much!!