Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i have QlikSense HR Model and i need to do Section Access
i have Excel with UserName, Access(User/Admin) and Sheets Colums and i give each user access to
see different Sheets
the SA is working..
now I need that they will see Central Unit,Brigade,Unit ( 3 different fields.. Hirarcy is Central Unit>Brigade>Unit)
i added those columns into the excel and Made Central Unit&'|'&Brigade&'|'&Unit as a Key to connect to the UnitTable in the script ( have all units fields and made there this key too)
if i write each user specific units(all 3 fields) its working
if i put * in each of those fields its dont work cause the unit table dont have *&'|'&*&'|'&* in his Key
i wrote if Cental Unit =* ,* else Central Unit&'|'&Brigade&'|'&Unit that means that * in central unit so he can see all else if i wrote specific give me this .
so this Combination dont work
Central Brigade Unit
aa * *
bb cc *
i tried also to remove this key and just write this fields but its create some Syntetic keys and dont work
Please Help
Thanks
Hi, I would try to use a keyword like 'ALL' instead of an sterisk, as the asterisk could be interpreted in a differnt way than just a text.
And you can create an intermediate table the relates the combination with the ALL keyword with all the real values of that field, as an example:
SectionAccess:
LOAD
Upper(Central&Brigade&Unit) as SA
Inline [
Central, Brigade, Unit
aa,ALL,ALL
bb,cc,ALL
];
Hierachy:
LOAD *, Central&Brigade&Unit as Combination Inline [
Central,Brigade,Unit
aa,aa,aa
aa,aa,bb
aa,bb,cc
bb,dd,ff
];
Intermediate:
LOAD
Combination,
Upper(Combination) as SA
Resident Hierachy;
concatenate (Intermediate)
LOAD
Combination,
Upper(Central&Brigade&'ALL') as SA
Resident Hierachy;
concatenate (Intermediate)
LOAD
Combination,
Upper(Central&'ALL'&'ALL') as SA
Resident Hierachy;
Hi, I would try to use a keyword like 'ALL' instead of an sterisk, as the asterisk could be interpreted in a differnt way than just a text.
And you can create an intermediate table the relates the combination with the ALL keyword with all the real values of that field, as an example:
SectionAccess:
LOAD
Upper(Central&Brigade&Unit) as SA
Inline [
Central, Brigade, Unit
aa,ALL,ALL
bb,cc,ALL
];
Hierachy:
LOAD *, Central&Brigade&Unit as Combination Inline [
Central,Brigade,Unit
aa,aa,aa
aa,aa,bb
aa,bb,cc
bb,dd,ff
];
Intermediate:
LOAD
Combination,
Upper(Combination) as SA
Resident Hierachy;
concatenate (Intermediate)
LOAD
Combination,
Upper(Central&Brigade&'ALL') as SA
Resident Hierachy;
concatenate (Intermediate)
LOAD
Combination,
Upper(Central&'ALL'&'ALL') as SA
Resident Hierachy;