Hiding the Expression based on the user login through session access

[mohanrajsubrama]

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.

[anushree1]

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

[pradosh_thakur]

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

[mohanrajsubrama]

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.

[mohanrajsubrama]

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

Thanks in Advance,
Mohan

[anushree1]

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