topic Re: Data Level Security In Only Qliksense in Management & Governance

Data Level Security In Only Qliksense

panipat1990 — Mon, 20 Nov 2017 12:16:46 GMT

Dear Team,

I tried many times Data Security in Qlik Sense. But i didn't get it.

When i open my App it Says Access is Dined.

Kindly Tell me Procedure how to Implement Field Level Security in QlikSense.

Would be appreciate If Anyone help me for resolving this.

Thanks

Gourav

Re: Data Level Security In Only Qliksense

shraddha_g — Tue, 21 Nov 2017 05:02:05 GMT

What is your Section Access Script?

Re: Data Level Security In Only Qliksense

panipat1990 — Tue, 21 Nov 2017 07:31:22 GMT

I used this Script

Section Access;

LOAD * INLINE [

ACCESS UserID Link

USER ABC\Peter NA

USER ABC\Sohan SA

USER ABC\Rohan CA

];

Section Application;

SecLinkTale:

LOAD * INLINE [

Link, COUNTRY

NA, North America

SA, South America

];

When i Publish app then it is working ok at hub Using Crendentail

UserName:-ABC/Peter

Password:-Training

Peter See Only North America Sale

But When i open in Work enviornment then it is saying Access is denied.

Re: Data Level Security In Only Qliksense

panipat1990 — Tue, 21 Nov 2017 10:14:30 GMT

Did any one implement Field level security in qliksense.

If did,How Kindly Tell me

Re: Data Level Security In Only Qliksense

shraddha_g — Tue, 21 Nov 2017 10:49:08 GMT

Try Below Code:

Section Access;

LOAD * INLINE [

ACCESS , USERID, LINK

USER , ABC\Peter , NA

USER , ABC\Sohan , SA

USER , ABC\Rohan , CA

];

Section Application;

SecLinkTale:

LOAD * INLINE [

LINK, COUNTRY

NA, North America

SA, South America

];

Everything should be in UpperCase.

Make sure you take a backup before applying section access.

Re: Data Level Security In Only Qliksense

panipat1990 — Tue, 21 Nov 2017 10:54:59 GMT

Did you do in Qliksense.

i tried UPPERCASE But When i Open in my Work environment it say Access is denied

Re: Data Level Security In Only Qliksense

shraddha_g — Tue, 21 Nov 2017 11:01:19 GMT

Yes I do it in Qliksense Onlly

You have that user in list for sure?

Re: Data Level Security In Only Qliksense

panipat1990 — Tue, 21 Nov 2017 11:08:51 GMT

Sure i used those user in script ..

that users i login in qliksense in hub..

But confusion is that why is not opening at work environment?????

Re: Data Level Security In Only Qliksense

shraddha_g — Tue, 21 Nov 2017 11:12:51 GMT

There is no spelling mistake in User name right?

Re: Data Level Security In Only Qliksense

panipat1990 — Tue, 21 Nov 2017 11:16:19 GMT

Right No Mistake

Re: Data Level Security In Only Qliksense

shraddha_g — Tue, 21 Nov 2017 11:22:59 GMT

In Access Column, Try ADMIN instead of USER

Re: Data Level Security In Only Qliksense

panipat1990 — Tue, 21 Nov 2017 11:48:20 GMT

it is working but When i login Sohan I seeing All Country Wise Sale.But Above Script Sohan Access Only South America..But his login Show all Division Sale

Re: Data Level Security In Only Qliksense

shraddha_g — Tue, 21 Nov 2017 11:55:28 GMT

Make sure that Country Field is linked with Data Model

Re: Data Level Security In Only Qliksense

panipat1990 — Tue, 21 Nov 2017 11:58:26 GMT

SURE IT IS CONNECTED COUNTRY IN DATA MODEL

Re: Data Level Security In Only Qliksense

panipat1990 — Tue, 21 Nov 2017 12:05:26 GMT

I done it by user level.but One thing when i open in my Work Environemnt it is showing Access is denied

Re: Data Level Security In Only Qliksense

shraddha_g — Tue, 21 Nov 2017 12:12:22 GMT

I guess problem with 'Access'.

Admin Access will have whole data access.

And If you change it to user then only Data reduction will take place.

For User Access you can access app present in Work Environment.