Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Section Access;
LOAD * Inline
[ACCESS,USERID,PERSON_IDENTIFIER,REPORTS_TO
ADMIN,TAG\T234GC,432555,63225
ADMIN,TAG\T564GS,1761528,432555
ADMIN,TAG\T0386HC,932143,63225
ADMIN,INTERNAL\SA_SCHEDULER,13212];
I need to get who is login to the Qlik sense Application so i can get that variable value i and parse to subsequent queries to generate the Charts ..
Section Application;
// LET vSA1 = UPPER(peek('PERSON_IDENTIFIER',0,'SECTION_ACCESS_FIELDNAME'));
LET vSA1 = UPPER(peek('PERSON_IDENTIFIER')); //(But by default iam getting 13212 sa scheduler value )
For example if this person logs in TAG\T234GC , i need 432555 in variable (vSA1 =432555)
For example if this logs in TAG\T564GS,i need in 1761528 (vSA1 =1761528)
So in that scenario how i parse person identifier in section application queries ..
for example how to get below value in the where clause ..
WHERE ROOT.REPORTS_TO_USER = $(vSA1) and TJOBAT.AUTHORIZED_PERSON In $(vSA1)
Becuase --> SET vSA1 = Only(PERSON_IDENTIFIER); --> returns as string field -> Only(PERSON_IDENTIFIER) ..
Thanks for the reply