Discussion Board for collaboration on QlikView Scripting.
Have a requirement is that
Have below data
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
In that case LRM and GRM names should be different.It is better to use ID's.
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
gwassenaar jagan Can please help me out
first of all you will use upper case of fields, because section access will work only on upper case values.
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
Hope it helps
look at this app.
username - ram
Why dont you load one table with user and countries he has access to.PFA
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
Section Access Table:
USERID PASSWORD EMPID
A 1234 101
B 1234 102
C 1234 103
D 1234 104
E 1234 105
EMPID POSITION LOCATION
101 GRM INDIA
102 LRM US
103 LRM UK
104 GRM UAE
105 LRM INDIA