Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

ramachandra_gee
New Contributor II

section access mask

Hi Hunters,

I have a requirement in the section access like below.

input.

   

sitestatedisitnctsales
Indiaapongole80
Indiaapnell85
indiabhpparadise23
indiabhpcellorium45
usremedycalom86
usremedysiral75
kenadakalosarichel66
kenadakalosasilaj89
kenadasumeraaparlak25
non-southpradeshkilkut36

non-south


pradeshsuraj25

output for admin.


   

sitestatedisitnctsales
Indiaapongole80
Indiaapnell85
indiabhpparadise23
indiabhpcellorium45
usremedycalom86
usremedysiral75
kenadakalosarichel66
kenadakalosasilaj89
kenadasumeraaparlak25
non-southpradeshkilkut36
non-southpradeshsuraj25


out put for who is having india access

   

   

sitestatedisitnctsales
Indiaapongole80
Indiaapnell85
indiabhpparadise23
indiabhpcellorium45
site2remedydefault86
site2remedydefault75
site3kalosadefault66
site3kalosadefault89
site3sumeradefault25
non-southpradeshkilkut36
non-southpradeshsuraj25


out put for  who is having us access

   

sitestatedisitnctsales
site1apdefault80
site1apdefault85
site1bhpdefault23
site1bhpdefault45
usremedycalom86
usremedysiral75
site3kalosadefault66
site3kalosadefault89
site3sumeradefault25
non-southpradeshkilkut36

non-south

pradeshsuraj25

2 Replies
antoniotiman
Honored Contributor III

Re: section access mask

Hi,

SECTION Access;
LOAD * Inline [
ACCESS,USERID,PASSWORD,SITE
ADMIN,ADMIN,ADMIN,
USER,USER1,USER1,INDIA
USER,USER1,USER1,NON-SOUTH
USER,USER2,USER2,US
USER,USER2,USER2,NON-SOUTH
]
;
SECTION Application;

LOAD Upper(Site) as SITE,* Inline [
Site state disitnct sales
India ap ongole 80
India ap nell 85
India bhp paradise 23
India bhp cellorium 45
us remedy calom 86
us remedy siral 75
kenada kalosa richel 66
kenada kalosa silaj 89
kenada sumera aparlak 25
non-south pradesh kilkut 36
non-south pradesh suraj 25
]
(delimiter is
spaces);

See Attachment.

Users :

ADMIN,ADMIN

USER1,USER1

USER2,USER2

Regards,

Antonio

ramachandra_gee
New Contributor II

Re: section access mask

Hi Antonio,

Thanks for quick reply, but this is not my requirement.

the attached qvw is reducing the data using section access, but my requirement is we need to mask the data  which is not relevant to the user.

Thanks,

Ram.

Community Browser