topic Re: Data Security with Section Access in QlikView

Data Security with Section Access

Mon, 26 Jan 2026 18:19:17 GMT

Hello,

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?

Thanks

Re: Data Security with Section Access

MK_QSL — Mon, 13 Apr 2015 17:06:43 GMT

You can use OMIT to achieve this..

Re: Data Security with Section Access

Miguel_Angel_Baeyens — Mon, 13 Apr 2015 17:09:50 GMT

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.

Miguel

Re: Data Security with Section Access

Anonymous — Mon, 13 Apr 2015 18:04:03 GMT

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.