Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
krishnamraju513
Contributor

Section Access with Reduction Field

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;

1 Solution

Accepted Solutions
krishnamraju513
Contributor

Re: Section Access with Reduction Field

ntname in the section of access


I found explanation from this discussion regarding my problem .

6 Replies
Chanty4u
Esteemed Contributor III

Re: Section Access with Reduction Field

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;

krishnamraju513
Contributor

Re: Section Access with Reduction Field

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 .

trdandamudi
Honored Contributor

Re: Section Access with Reduction Field

Just add *

syukyo_zhu
Contributor III

Re: Section Access with Reduction Field

Hi,

don't forget

star is *;

after

Section Application;

trdandamudi
Honored Contributor

Re: Section Access with Reduction Field

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.

krishnamraju513
Contributor

Re: Section Access with Reduction Field

ntname in the section of access


I found explanation from this discussion regarding my problem .

Community Browser