Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

vardhancse
Valued Contributor II

Section Access with multiple fields Or condition

Hi,

Have a requirement is that

Have below data

     

GroupCountryGRMCustomerLocationLRM
Group1IndiaName1Customer1IndiaName1
Group1IndiaName1Customer2SingaporeName2
Group1IndiaName1Customer3AustraliaName3
Group1IndiaName1Customer4ChinaName4
Group2AustraliaName3Customer1SingaporeName2
Group2AustraliaName3Customer2AustraliaName3
Group2AustraliaName3Customer3ChinaName4
Group2AustraliaName3Customer4IndiaName1

Now my section access should work like if a user login in to dashboard, he should be either GRM/LRM then then only he should see his relevant data.

Can please any one let me know the solution for the same, thanks in advance for your support.

PFA sample QVW

18 Replies
hariprasadqv
Contributor III

Re: Section Access with multiple fields Or condition

Hi,

In that case LRM and GRM names should be different.It is better to use ID's.

Thanks.

vardhancse
Valued Contributor II

Re: Section Access with multiple fields Or condition

Hi,

The condition is that the login user to dashboard should see the data only for which he is either GRM & LRM, that is why we should have or condition

vardhancse
Valued Contributor II

Re: Section Access with multiple fields Or condition

gwassenaarjagan‌ Can please help me out

Not applicable

Re: Section Access with multiple fields Or condition

Hi,

first of all you will use upper case of fields, because section access will work only on upper case values.

Regards

Vimlesh

vardhancse
Valued Contributor II

Re: Section Access with multiple fields Or condition

Hi thanks for your reply,

Yeah I know section access will work on upper case I tried merging both GRM and LRM using the condition like

UPPER(IF(len(trim(GRM))>0,GRM,'<ANY>') &'|'& IF(len(trim(LRM))>0,LRM,'<ANY>')) as AuthID 

in fact table

Not applicable

Re: Section Access with multiple fields Or condition


Try this

Hope it helps

Not applicable

Re: Section Access with multiple fields Or condition

hi,

look at this app.

username -  ram

password-  ram

Regards

Vimlesh

Not applicable

Re: Section Access with multiple fields Or condition

Hi,

Why dont you load one table with user and  countries he has access to.PFA

ADMIN1,ADMIN1

USER1,USER1

hariprasadqv
Contributor III

Re: Section Access with multiple fields Or condition

Hi,

1.As vimlesh20‌ said SECTION ACCESS elements shoud be in UPPER CASE.

2.Regarding your case. Either LRM or GRM they should be identified by a key value right, so use that key ion the section access tabel.

3.In the mapping tabel map the keys with their Role(GRM/LRM)

See the below prototype. It may help you

Ex:

Section Access Table:

USERID  PASSWORD    EMPID

A              1234                    101

B              1234                    102

C              1234                    103

D              1234                    104

E              1234                    105



MAPPING TABLE:

EMPID          POSITION          LOCATION

101               GRM                    INDIA

102               LRM                     US

103               LRM                     UK

104               GRM                    UAE

105               LRM                    INDIA


Thanks


Community Browser