Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

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
Employee
Employee

Re: Data reduction for multiple fields in Qlik Sense

3 Replies
Not applicable

Re: Data reduction for multiple fields in Qlik Sense

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

Re: Data reduction for multiple fields in Qlik Sense

Dan:

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

Employee
Employee

Re: Data reduction for multiple fields in Qlik Sense

Community Browser