Conditional Display of Measures based on values in a Data Field

[rashmigg]

Dear Fellow Community Members (I already sound like an amateur😁),

I am trying to find my feet within Qlik space by building a basic app in Qliksense for our managers who wish to review some clinical indicators. Data Model is very simple and straight forward. I have completed my Master Items and also build a rudimentary app around displaying these measures and pivot tables etc.

I also have managed to get the section access working at a simple level with 4 users (1 at admin level and 3 at the user level with access based on the Specialty (using a field called ‘(specialty_description)’ they belong to – pseudo access at this level for testing on the server).  I have managed to check that these 4 users are able to see the reduced data based on the specialty they belong to.

Now, I am finding it extremely hard to implement conditional display of a few measures from the Master Items which Users belonging to One specialty should see but not others.

So if USER A belongs to General Surgery – They should only see the Measures/Clinical Indicators for their department based on their specialty () but USER B who belongs to another specialty should not see the measures USER A can see.

Maybe this is easy for some but Not sure how I should be able to hide some measures from others.

Also some of my other objects on the same sheet will need to show/hide based on this conditional display.

Hope this helps understand the confusion I am in( at a beginner level). Please help. 

Can provide some more information based on what others make of this initial problem statement.

Many Thanks in advance

Rashmi

[micheledenardi · Accepted solution]

Rashmi,

depends from your environment.

If you have to setup this solution only for few users you can start using osuser() function in the "Show column if" of your table:

Formula: if(SubStringCount(OSUser(),'user1','user2','user3')>0,1,0)