Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Section Access Simplification

I am restricting sheet access per user based on the following conditional formatting for the sheet:

=Match(QVUser(),'MWENDERA PORTIFA','PORTIFA MWENDERA','CHITEMERERE CHRIS','DEDA BEN','BEN DEDA','MUDZAMI ONESIMOS','ONESIMOS MUDZAMI','MAUMBE CAROL','CAROL MAUMBE','MARANDU NHAMO','NHAMO MARANDU','NDORO PRIMROSE','PRIMROSE NDORO')


This becomes too demanding the higher the number of users.  Is there a way to simplify this based on a database load or something else i.e. without having to type each QVUser()?


Regards.

11 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

You'll have to initial-data-reduce the values for field View. What you could do is name the flag columns in your security Excel the same as the values in field View (and probably the Sheet labels), and create a reduction table based on these values.

For example with your demo data, User1 would only find View values 'Patents' and 'FDA' in the listbox (aside from the default sheets that everone can see). User2 would find view values 'Generics' and 'Shopping' in that listbox.

Anonymous
Not applicable
Author

Thank you Peter for your input. I will look into that