topic Re: section access - multi-field data reduction in QlikView

section access - multi-field data reduction

Fri, 14 Sep 2012 08:26:54 GMT

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?

Re: section access - multi-field data reduction

Anonymous — Fri, 14 Sep 2012 08:32:45 GMT

http://www.youtube.com/watch?v=yADMnvEvGEg

hopes it will help you

Re: section access - multi-field data reduction

rajni_batra — Fri, 14 Sep 2012 08:33:48 GMT

add one more column named as division if u r applying section access through excel file.

Re: section access - multi-field data reduction

Fri, 14 Sep 2012 08:50:25 GMT

Hi John,

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.

e.g ;

Data:

Country, Dividion

USA, MM

USA, FI,

ISR, MM

ISR, CO

So if you reduce by USA, CO or ISR, FI the reduce will fail.

Hope it helps.

Regards

Yigal

Re: section access - multi-field data reduction

Miguel_Angel_Baeyens — Fri, 14 Sep 2012 08:56:45 GMT

Hi John,

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.

Miguel