Section access on two fileds - Qlik Community

kunkumnaveen · ‎2017-09-06

Hello All,

I need to apply section access on two fields,

I have gone through few links but i haven't got any thing from those links,can any suggestion plz ,how to make it work

Section Access;

LOAD

"ACCESS",

"USERID",

DESCRIPTION1,

SECTOR

FROM [lib://AttachedFiles/SectionAccess.xlsx]

(ooxml, embedded labels, table is Sheet1);

Section Application;

Thanks

PrashantSangle · ‎2017-09-06

Hi,

Try making key of those field then Try.

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

vinieme12 · ‎2017-09-06

can you upload a sample app

?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

kunkumnaveen · ‎2017-09-06

Thanks for your quick reply ,

Key u mean like this

Section Access;

LOAD

"ACCESS",

"USERID",

DESCRIPTION1&'|'&SECTOR as KEY

FROM [lib://AttachedFiles/SectionAccess.xlsx]

(ooxml, embedded labels, table is Sheet1);

Section Application;

kunkumnaveen · ‎2017-09-06

hi,

i wish but its client data

its_anandrjs · ‎2017-09-06

Are you using this table on the Qliksense if so you have to create the Rules over there for providing security to your app please check. If you are using this excel in qlikview then that two fields to be there in this excel file will help you here.

PrashantSangle · ‎2017-09-06

Yes.

Also, try what its.anandrjs‌ suggested.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

kunkumnaveen · ‎2017-09-06

Hi,

I am using this table in Qlik sense ,i am loading from excel ,

i didn't get this ...

if so you have to create the Rules over there for providing security to your app please check

its_anandrjs · ‎2017-09-06

In Qliksense you have to provide security from creating user rules for providing access to the user and there re options like Field level access, User level access, Object level etc

Check this on Qliksense Help

https://help.qlik.com/en-US/sense/June2017/Subsystems/ManagementConsole/Content/preinstalled-QMC-sec...‌

https://help.qlik.com/en-US/sense/June2017/Subsystems/ManagementConsole/Content/security-rules-overv...

kunkumnaveen · ‎2017-09-06

Ohh Anand ,i dont have QMC with me .cant i do this at script level,

In Qliksense i did section access on one field along with "ACCESS","USERID" which work pretty good,but when it come to two fields i am bit confuse .