This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration on QlikView Management.
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 :
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
ntname in the section of access
I found explanation from this discussion regarding my problem .
View solution in original post
just add * for all admin
Load * INLINE
ADMIN , ABC\qvadmin ,*
ADMIN , ABC\123 ,*
ADMIN , ABC\456,*
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 .
Just add *
star is *;
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.
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?