Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Contributor III

Section access on two fileds

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

10 Replies

Re: Section access on two fileds

Hi,

Try making key of those field then Try.

Regards,

Regards,
Prashant Sangle
vinieme12
Esteemed Contributor II

Re: Section access on two fileds

can you upload a sample app

?

kunkumnaveen
Contributor III

Re: Section access on two fileds

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

Re: Section access on two fileds

hi,

i wish but its client data

Re: Section access on two fileds

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.

Re: Section access on two fileds

Yes.

Also, try what its.anandrjs‌ suggested.

Regards

Regards,
Prashant Sangle
kunkumnaveen
Contributor III

Re: Section access on two fileds

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

Re: Section access on two fileds

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

Re: Section access on two fileds

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 .

Community Browser