topic Re: Section Access - selection work but not data reduction in QlikView

Section Access - selection work but not data reduction

blaise — Wed, 07 Nov 2012 15:24:12 GMT

Hello

I have created a section acess script which work when ticking the "initial selection based on section access" but i does not work then choosing "intial data reduction based on section access". Does anyone have a clue what the issue is? I find it rather strange that the initial selection works fine but not the data reduction (the user is denied access to the document).

All fields (and fieldvalues) are in uppercase and loaded from an XLS sheet (making some temporary tables before the actual Section Access is loaded).

Re: Section Access - selection work but not data reduction

IAMDV — Fri, 09 Nov 2012 12:38:55 GMT

You need to make the Reduction field and Section Access Fields in UPPER CASE. Although, if you are using INLINE Load then QlikView implicitly converts them to UPPER CASE. But if you are loading from Excel / Databases / Other Sources then you need to make the field values in UPPER CASE.

Also, please be very careful using the '*' (Wildcard) because it doesn't mean all the values in the Actual Field. It means distinct values you have specified in Section Access Table. Unless you have specified all the distinct values within Section Access.

APlease post your QVW file and I can look into it.

Please read this thread for detailed information and example:

http://community.qlik.com/message/247356#247356

Good luck!

Cheers,

Re: Section Access - selection work but not data reduction

IAMDV — Tue, 13 Nov 2012 16:07:53 GMT

Is this resolved? Managed to get it to work?

Thanks,

Re: Section Access - selection work but not data reduction

blaise — Wed, 05 Dec 2012 09:30:31 GMT

I added the values into a INLINE load instead and that worked. Will stick to that solution until i find time to investigate further. Investigate Section Access using NTNAMe is a bit hard .

Thanks for the help though, even if it didn't solve my issue.