topic Re: Section Access with Reduction Field in QlikView

Section Access with Reduction Field

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

Hi All ,

I have a Reduction field name "COM_CODE" which has around 450 rows of data in it .

I've to create section access for this case to restrict USER to see only certain COM_CODE values .

But for ADMIN Access i need to show all 450 rows of data . So, what should i enter in reduction field for ADMIN ?

Should I enter * or BLANK .

My Section Access Script is :

Section Access;

Load * INLINE

[

ACCESS , NTNAME ,COM_CODE

ADMIN , ABC\qvadmin

ADMIN , ABC\123

ADMIN , ABC\456

USER , ABC\789 , 0001

USER , ABC\789 , 0002

USER , ABC\789 , 0003

USER , ABC\789 , 0004

USER , ABC\789 , 0005

];

Section Application;

Re: Section Access with Reduction Field

Chanty4u — Tue, 14 Jun 2016 08:46:29 GMT

just add * for all admin

Section Access;

Load * INLINE

[

ACCESS , NTNAME ,COM_CODE

ADMIN , ABC\qvadmin ,*

ADMIN , ABC\123 ,*

ADMIN , ABC\456,*

USER , ABC\789 , 0001

USER , ABC\789 , 0002

USER , ABC\789 , 0003

USER , ABC\789 , 0004

USER , ABC\789 , 0005

];

Section Application;

Re: Section Access with Reduction Field

Anonymous — Tue, 14 Jun 2016 08:48:47 GMT

But if i use * for admin , it will only capture the COM_CODE values defined in Section Access Script .

I need ADMIN to Capture all 450 values in COM_CODE field .

Re: Section Access with Reduction Field

trdandamudi — Tue, 14 Jun 2016 08:50:02 GMT

Just add *

Re: Section Access with Reduction Field

syukyo_zhu — Tue, 14 Jun 2016 08:52:16 GMT

Hi,

don't forget

star is *;

after

Section Application;

Re: Section Access with Reduction Field

trdandamudi — Tue, 14 Jun 2016 10:36:33 GMT

When you use * it will not restrict the values. It will show all the 450 values for ADMIN. If you still think there is an issue can you please share a sample app.

Re: Section Access with Reduction Field

Anonymous — Thu, 16 Jun 2016 03:11:04 GMT

ntname in the section of access‌

I found explanation from this discussion regarding my problem .

Re: Section Access with Reduction Field

NickP_DF — Wed, 04 Aug 2021 06:08:43 GMT

Hello guys,

what about if I need to allow a user (not admin) to see all the 450 values in COM_CODE field?

Is there a way to avoid the list of all them and then the "*" grant?

Thanks.