Data reduction for multiple fields in Qlik Sense

Tue, 21 Jul 2015 16:44:06 GMT

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

Re: Data reduction for multiple fields in Qlik Sense

Thu, 01 Oct 2015 20:05:17 GMT

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.

Re: Data reduction for multiple fields in Qlik Sense

Mon, 19 Oct 2015 21:53:45 GMT

Dan:

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

Re: Data reduction for multiple fields in Qlik Sense

hic — Tue, 20 Oct 2015 08:36:43 GMT

See Data Reduction Using Multiple Fields

HIC

topic Data reduction for multiple fields in Qlik Sense in Connectivity & Data Prep

Data reduction for multiple fields in Qlik Sense

Re: Data reduction for multiple fields in Qlik Sense

Re: Data reduction for multiple fields in Qlik Sense

Re: Data reduction for multiple fields in Qlik Sense