Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Not applicable

Data Security with Section Access


I am trying to use section access to select a field when a certain user logs in to Qlikview. I would like all the data to show but only a specific field to be selected and locked for the said user (i.e. in my case, a territory). When I use section access, all other data completely disappears and I still need it to feed some comparison charts.

Any ideas?


3 Replies

Re: Data Security with Section Access

You can use OMIT to achieve this..


Re: Data Security with Section Access

Hi Thomas,

Try using a trigger that locks a selection in a field, or a button that has an action which locks a value in the field depending on the user.

Indeed, section access removes all data not associated with the user.

Another option is create those aggregates in the script, so you can still see others data, but without detail.


Esteemed Contributor III

Re: Data Security with Section Access

Use "Initial Selection Based on Section Access" instead of  "Initial Data Reduction Based on Section Access".  And, lock the field which you use for this by the OnOpen trigger.

Community Browser