topic Re: Hiding the Expression based on the user login through session access in QlikView

Hiding the Expression based on the user login through session access

mohanrajsubrama — Sat, 16 Nov 2024 21:12:30 GMT

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.

Re: Hiding the Expression based on the user login through session access

anushree1 — Thu, 21 Mar 2019 06:04:35 GMT

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

Re: Hiding the Expression based on the user login through session access

pradosh_thakur — Thu, 21 Mar 2019 07:35:18 GMT

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

Re: Hiding the Expression based on the user login through session access

mohanrajsubrama — Thu, 21 Mar 2019 09:11:10 GMT

Thanks for your help.
I tried with the above approach just with 2 users .But the problem is when I changed the flag to 1 to 0 ,the above expression is not handling it.
I mean initially if the flag is 1 I am able to see the column. After changing it to 0 ,I am still seeing the column.

Re: Hiding the Expression based on the user login through session access

mohanrajsubrama — Thu, 21 Mar 2019 09:12:37 GMT

Hi ,
This method I tried before Pradosh..But this looks like omitting the field rather the whole expression.

Thanks in Advance,
Mohan

Re: Hiding the Expression based on the user login through session access

anushree1 — Thu, 21 Mar 2019 09:15:57 GMT

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