Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

show/no show masking of dimension labels based on accesslevel

I have one additional use case that I need to be able to support.  I have added an additional column in my Edit Script that is ACCESSLEVEL and it will be set to either All or Limited.  If it is Limited it will provide the masking logic that you previously provided, but if it is all then I want all of the actual named DEPTs to be shown and not masked.  I added the following logic, but it did not work.

=PICK(MATCH(ACCESSLEVEL,

'All'  // When a user signs in with this as their ACCESSLEVEL I want the DEPT dimension to show w/o masking

  ,'Limited')  // This works as you defined

,DEPT

,aggr(if(len(only({<DEPT=, USERID=>}DEPT))> 0 ,

  if(only({<DEPT=, USERID=>}DEPT)=Only(DEPT) ,DEPT,

  'Dept' & FieldIndex('DEPT', only({<DEPT=, USERID=>}DEPT))))

, DEPT)

)

What am I missing?

0 Replies