Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
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.


'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


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

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

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



What am I missing?

0 Replies