Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

section access - multi-field data reduction

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?

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: section access - multi-field data reduction

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

4 Replies
kasdalinassim
Contributor

Re: section access - multi-field data reduction

rajni_batra
Valued Contributor

Re: section access - multi-field data reduction

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

Not applicable

Re: section access - multi-field data reduction

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

MVP
MVP

Re: section access - multi-field data reduction

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

Community Browser