Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
kusha_2007
Contributor III
Contributor III

Qlikview Section Access not working


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.

2 Replies
Stoyan_Terziev
Partner
Partner

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.

Brett_Bleess
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.