topic Qlikview Section Access not working in QlikView

Qlikview Section Access not working

kusha_2007 — Sat, 16 Nov 2019 06:19:13 GMT

Section Access;
star is ALL;

Security:
LOAD UPPER(Trim(ACCESS)) AS ACCESS,
UPPER(Trim(NTNAME)) AS NTNAME,
// UPPER(Region) AS REGION_REDUCTION,
// UPPER(Brand) AS BRAND_REDUCTION,
// UPPER([USER TYPE]) AS USER_TYPE_REDUCTION,
UPPER(FLAG_ADMIN) AS FLAG_ADMIN

FROM
[..\0_BAS_EXC\QVW_RIGHTS\FuWeChat Section Access Matrix.xlsx]
(ooxml, embedded labels, table is [Security]);

Hello All ,

My section Access is defined as shown below.

Section Application;

ADMIN_REDUCTION:
LOAD DISTINCT UPPER(Trim(NTNAME)) AS NTNAME,
FLAG_ADMIN AS FLAG_ADMIN2

FROM
[..\0_BAS_EXC\QVW_RIGHTS\FuWeChat Section Access Matrix.xlsx]
(ooxml, embedded labels, table is [Security]);

It works fine from the Qlikview Desktop but always shows the first value from the table in Security table , so no matching values .Please suggest what has gone wrong.

Re: Qlikview Section Access not working

Stoyan_Terziev — Sat, 16 Nov 2019 16:04:07 GMT

Hi Kusha,

So you are saying that in Desktop it works right? So the problem is in the Access Point?

Is it that the ADMIN_REDUCTION table is showing the top value where you'd expect multiple values instead?

Can you temporary remove the field FLAG_ADMIN from the Section Access load an see if the issue persists?

Kind regards,

S.T.

Re: Qlikview Section Access not working

Brett_Bleess — Wed, 20 Nov 2019 14:55:10 GMT

Kusha, have a look at the following Design Blog post, believe it should be of some further help in addition to Stoyan's comments.

https://community.qlik.com/t5/Qlik-Design-Blog/Data-Reduction-Using-Multiple-Fields/ba-p/1474917

Regards,
Brett