Conditional Column Based on User logged in Qliksense Dashboard

[rsdhavle]

In case we have to make a column value conditional based on who has logged in how can we do it? We can't use OMIT in this case as complete object becomes incomplete visualization when we use OMIT.

Example:

If user = 1, values in column = X

user = 2 values in column = Y

[MK9885]

Never tested and I think it won't work but just an idea....

if(osuser()= 'DOMAIN\USER1', Sum (Value),

if(osuser()= 'DOMAIN\USER2', Sum (Rates)))

Usually you cannot hide the column unless it is Section Access OMIT field

unless you write a new security rule in QMC but that would disable the object based on user name and not column.

Have you looked into Container?

I think there is an extension for Conditional Hide/Show of charts within the container.

[rsdhavle]

I dont want to hide field and OMIT has issues in Qliksense. It shows incomplete visualisation.

OSuser is always system user that is the another problem

[MK9885]

osuser will not return same id always...

it would their AD name which is unique

[rsdhavle]

yes thats the reason unable to make it conditional based on which user is accessing

[MK9885]

use conditional hide and show container extension.