Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
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 - Creator III
Partner - Creator III

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
Employee
Employee

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.