Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Section Access: Data reduction problem

Hi All,

I am putting the following section access code in my QV file

Section Access;

SQL SELECT UPPER(username) AS NTNAME,

    case  UPPER(username) when 'ST12\ARIF' then 'ADMIN' else 'USER' end AS ACCESS

FROM [DTV].dbo.users;

Section Application;

Then I load the rest of tables. The tables are interlinked as following

dm.png

The problem is that the branches, desks etc are visible to users based on data reduction (Consultantdesk table), but data in other tables are not visible to any users. Is it because the section access is joined to consultantdesk table but not directly linked with other tables? What is the problem with my logic?

Regards

Arif

2 Replies
Highlighted
Creator III
Creator III

Re: Section Access: Data reduction problem

I don't see a fundamental problem within your schema.  Is it possible that NTNAME "John" does not have links back to the rest of the data?

Highlighted
Not applicable

Re: Section Access: Data reduction problem

Hi Aaron,

You are right. Those users did not have any linkback to other tables data. I have resolved this now. Thanks

Regards

Arif