Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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