Section Access Buggy - 2 Field reduction

Thu, 31 May 2012 13:22:16 GMT

Hi guys, I am trying to get the attached section access to run smoothly... I have 2 fields and I am trying to limit the data where a country can be in either or both fields,

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REGION, PROFIT

ADMIN, ADMIN, ADMIN,

USER, USER5, U5, EUROPE, *

USER, USER5, U5, *, EUROPE

];

Section Application;

SALES:

LOAD * INLINE [

REGION, PROFIT

AFRICA, AFRICA

AMERICA, EUROPE

ASIA, OCEANIA

EUROPE, AMERICA

OCEANIA, EUROPE

];

I would expect user5 D in the above statement to see:-

OCEANIA, EUROPE

AMERICA, EUROPE

EUROPE, AMERICA

Any help is appreciated (basically I want Europe in 1 of 2 fields and it can be in one, both or neither)

Section Access Buggy - 2 Field reduction

Oleg_Troyansky — Thu, 31 May 2012 17:49:32 GMT

If I'm not mistaken, here are a few things to consider:

1. To facilitate Data Reduction in Sectino Access, each one of the Section Access Fields (such as REGION and PROFIT) need to be associated with another Section Application field - foer example Region and Profit (proper casing versus upper case).

2. In order to facilitate * for "all", each link needs to be created separately, in individual link tables, and not together in a single table.

topic Section Access Buggy - 2 Field reduction in QlikView

Section Access Buggy - 2 Field reduction

Section Access Buggy - 2 Field reduction