Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data reduction for multiple fields in Qlik Sense

After searching for some time on how to solve this problem I am stumped. I'm using section access in Qlik Sense to reduce fields by a management region in a report. E.g. "N. AMERICA", "SINGAPORE", "EUROPE"

This works wonderfully for most of my reports using section access. However due to some exceptions certain rows must be visible to these individuals based on a geographic region. Some sites are geographically in one region but managed by another, ie. a Singapore site is managed by North America.

There are two fields, M_Region and G_Region and I'd like to constrain just a few individuals by the second field, the rest by the first

Here's what I have so far:

section access;

LOAD * inline [

ACCESS, USERID, M_REGION,

USER, HQ\ADMIN, *,

USER, HQ\bob, *,

USER, HQ\frank, "TAIWAN",

USER, HQ\joe, "EUROPE",

USER, HQ\mary, "N. AMERICA",

USER, HQ\kevin, "SEA",

USER. HQ\jason, "TAIWAN",

USER, HQ\brandon, "CHINA",

USER, HQ\charles, "KOREA",

USER, HQ\edgar, "JAPAN",

USER, INTERNAL\SA_SCHEDULER, *,

];

section Application;

load

     "M_Region" as M_REGION,

...

Is it possible to selectively reduce fields? One for M_Region and another for G_Region?

Something like (M_REGION OR G_REGION)?

I know if I do another field after like: M_REGION, G_REGION it will omit the field entirely.

I also attempted to create a separate section access field with no results

1 Solution

Accepted Solutions
3 Replies
Not applicable
Author

Have you tried using a Lookup Table?  Mapping M_REGION and G_REGION to R_REGION(reporting region)

then assign access by R_REGION.   Just a guess, I haven't done this myself.

Not applicable
Author

Dan:

This concept worked for me. I used Heinrich Constrom's article on Generic Keys to generate the appropriate mapping relationships.

hic
Former Employee
Former Employee