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.
Not applicable

Remove Single User Data who opened the app

Hi All,

I have a requirement where in I have to remove the single row data , I know I can get the username by QV.OSuser to get the username and neglect him in all the expressions and Dimensions and come up with.

Issue here is my app is all ready, This is a requirement that just came, I just wanted to know where I can make single change such that it reflects in all tab and charts.

PS: I DON't WANT to RELOAD the app,but just to exclude the data of the user who opens it.

Example :

If jane uses the app I don't want him to see Jane data alone, but he can see all the persons data.Basically I am working for rating data so I basically I don't want any one to see their own data before it is officially announce. I know still he can asks someone to open it but still :-) that's the requirement is

Kalyan Sundaram Jagan Mohan QlikView Section Access Examples

5 Replies

Re: Remove Single User Data who opened the app

Hi,

Have a look at osuser() function.

Regards

ASHFAQ

MVP
MVP

Re: Remove Single User Data who opened the app

Hi Deepak,

You can implement it in a single shot, you have to change all your expressions in your Dashboard.  Create one variable like below

vUserName = OSUser()

Now in your set analysis try like this

=Sum({<User-={'$(=vUserName)'}>} MeasureName)

I think it is not possible with section access also.

Hope this helps you.

Regards,

Jagan.

Not applicable

Re: Remove Single User Data who opened the app

Thanks a lot for your reply Jagan Mohan . But as I mentioned I can do this by editing in all expressions and dimensions. But anyways Thanks a lot for your answer. Looking forward for your helps.

Loophole in this way is user can still search but yeah I can exclude searches from this field ,Thanks once again.

Not applicable

Re: Remove Single User Data who opened the app

As I have mentioned I am aware of this. Thanks for your reply anyways.

MVP
MVP

Re: Remove Single User Data who opened the app

Hi,

Even user search his name but the expression excludes his data so no issues.  He can just select his name that's it.

Regards,

Jagan.

Community Browser