Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Is it possible to hide the expression in the chart through session access.
EX: lets say I have the below pivot table with 2 dimension with 3 measures.
I have a user called David & Nancy. My requirement is when David logins he has to see product, Sub type Sales & Cost.
But when Nancy logins she has to see all the columns.
product | Sub type | sales | cost | margin |
A | AA | 1500 | 400 | 100 |
B | BB | 500 | 400 | 150 |
C | CC | 680 | 400 | 170 |
Regards,
Mohan.
You can try by creating an inline table with the user id and a flag for instance:
NAME FLAG
A 1
B 0
C 1
The above table must contain al the userIDs and mark those Ids for whom the expression must be visible as 1
in the conditional expression write if (only({<Name={'$(vID)'}>})FLAG)=1,1,0)
vID should be a variable declared as =OSUSER()
Please take care of the Case OSUSER and Names is the Inline table must be of same case
Have y tried using OMIT in the section access
https://www.qliktips.com/2011/04/blocking-user-access-to-field-using.html
https://community.qlik.com/t5/QlikView-Documents/Introduction-to-Section-Access/ta-p/1478878
well but thats probably because you are checking and for you the flag is 1
Change the flag to 0 on your Name in the inline table, hope its clear