Iv got my section access working. The only issue is I have a field that I manipulated so that if it is not within the department of IT, FINANCE, MARKETING, it lumps/groups it all into other.
LOAD * INLINE [
REDUCTION, DEPT_TITLE
1, IT
2, FINANCE
3, MARKETING
4, OTHER
];
Now when I test this to the original DEPT_TITLE on myself, I only see the data I set myself as. E.g. if I have 1 listed, I will only see IT. If I have 2 selected, I will only see FINANCE. After manipulating the original field and making it a master dimension (in order to group all non-relevant departments in OTHERS) is where the section access breaks and I am able to see all the listed departments. I am really hoping Qlik allows us to use section access on master dimensions.. really hoping there is a solution or a workaround. Could not find any documentation regarding this problem so I'm asking you all.
Thanks all.
