Need some help/idea regarding security implementation in Qlik Sense. We are developing a dashboard where some securty rules to be implemented for different territory mangers.
If a user has been given a access for a territory then he will be able to view data for his territory only. It is fine
but here is a catch. when he will login in the dashboard he can view only his territory data but at the same time there is one chart where one measure is for territory avg calculation based on all the territory data. and this chart values will be changed based on different filters.
Now when this territory manager logs in in that particular chart he will see the avg territory volume and his territory volume is same as data is reduced for his territory only.But I do not want this. I need the avg calculation to be done based on all the territories. i.e data reduction should not be there. is there any way we can achieve this?