Discussion board where members can get started with Qlik Sense.
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.
If user = 1, values in column = X
user = 2 values in column = Y
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.
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
osuser will not return same id always...
it would their AD name which is unique
yes thats the reason unable to make it conditional based on which user is accessing
use conditional hide and show container extension.