Data Security with Section Access

[#1]

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

[MK_QSL]

You can use OMIT to achieve this..

[Miguel_Angel_Baeyens]

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

[Anonymous]

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.