Discussion Board for collaboration related to Creating Analytics for QlikView.
I wonder if any one can help me.
I already have section access built in around the country the user is in, however, I now need an addition security added around the division (office) the user is in.
Does any one know of a way to do this or any examples out there that I can use?
Go to Solution.
There is one thing that took me a couple of hours to figure it out,
When you are reducing by two fields you need to have the exact combination of values between the two fields
at least once in your data.
So if you reduce by USA, CO or ISR, FI the reduce will fail.
Hope it helps.
hopes it will help you
add one more column named as division if u r applying section access through excel file.
Check the example codes in this post, this other post, this thread, among many others! All them discuss section access with two reduction fields, and one of those fields being at a greater level (say country > region, for example).
Hope that helps.