Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Conditional Column Based on User logged in Qliksense Dashboard

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

5 Replies
Highlighted
Master II
Master II

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.

Highlighted
Creator II
Creator II

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

Highlighted
Master II
Master II

osuser will not return same id always...

it would their AD name which is unique

Highlighted
Creator II
Creator II

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

Highlighted
Master II
Master II

use conditional hide and show container extension.