Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

User Exclusive Data

Hello,

I was curious as to whether there was a way to make various data on a sheet invisible to certain users. For example if I have a dashboard for sales reps with their sales numbers and I only want them to be able to view their data and not anyone else's, would that be possible through security rules? If so how?

4 Replies
sinanozdemir
Valued Contributor III

Re: User Exclusive Data

Hi,

You can accomplish this by using Section Access feature:

Here is the sample code in the Main tab - make sure that the field and column values which are based on user access are capitalized:

Capture.PNG

First - go to Document Properties and check both "Initial Data Reduction Based on Section Access" and "Prohibit Binary Load":

Capture.PNG

Second - Insert "Section Access" code by using "Load Inline" Statement:

From the below, you can see that I granted each user different access based on their names and mind that the column and field values are capitalized.

Capture.PNG

Then save the document and close it. When you open it again, it will ask you to enter a password:

Capture.PNG

In this case, I type PASS1 which is John's password and John can only see his sales figures:

Capture.PNG

I am also attaching the qvw.

Hope this helps.

Not applicable

Re: User Exclusive Data

Sorry I meant for Qlik Sense, not Qlikview.

sinanozdemir
Valued Contributor III

Re: User Exclusive Data

Sorry my bad. You actually tagged your question correctly, I failed reading it at comprehension.

This feature won't work in QlikSense and I think you should try to handle this on the server side.

Not applicable

Re: User Exclusive Data

Although Sinan's answer was for QlikView, it applies to Qlik Sense as well and the way to implement is almost identical.

Please take a look at this topic in the Qlik Sense online help site: help.qlik.com

Community Browser