topic Re: Section Access - Reduction field problem - straight from example in QlikView

Section Access - Reduction field problem - straight from example

Tue, 04 Mar 2014 15:28:22 GMT

Hi All,

I was trying to use the reduction field in section access. To test it I copied the example from the 'Introduction to Section Access' document from Qliktech. Unfortunately, when I login to the app as any of the users I get all of the information so the reduction hasn't worked.

I have attached a test doc to show this problem.

Can anyone please shed some light on this for me?

To access:

username = ADMIN

password = ADMIN

Cheers,

GPC

Re: Section Access - Reduction field problem - straight from example

quwok — Tue, 04 Mar 2014 15:36:07 GMT

You'll need to enable data reduction on the document.

Go to Settings > Document Properties..., go to the Opening tab, and select "Initial Data Reduction Based on Section Access".

Re: Section Access - Reduction field problem - straight from example

Carlos_Reyes — Tue, 04 Mar 2014 15:39:01 GMT

You may find this document may be useful:

Sheets Security with Section Access

Re: Section Access - Reduction field problem - straight from example

Tue, 04 Mar 2014 15:41:49 GMT

Thanks Kwok,

I do that, but can't make it stick?! I click apply then OK, then if I open document properties again it is unchecked again! Any ideas?

Re: Section Access - Reduction field problem - straight from example

PrashantSangle — Tue, 04 Mar 2014 15:44:42 GMT

Hi,

goto Document Properties->Opening->check Initial Data Reduction Based On Section Access,

also check Strict Exclusion

Re: Section Access - Reduction field problem - straight from example

Carlos_Reyes — Tue, 04 Mar 2014 15:49:01 GMT

Obvious but... You have to save the document after checking the "Initial Data Reduction..." option and close any QlikView instance in order to reopen the document and view the reduction in action.

Re: Section Access - Reduction field problem - straight from example

quwok — Tue, 04 Mar 2014 15:49:20 GMT

This is a document specific setting, did you make sure you saved the document afterwards?

Re: Section Access - Reduction field problem - straight from example

Tue, 04 Mar 2014 15:53:46 GMT

Yes I did save it and reopen, but that check box does not stay checked... bizzare... I might try recreating the file and see if that helps.

Re: Section Access - Reduction field problem - straight from example

PrashantSangle — Tue, 04 Mar 2014 15:58:37 GMT

Hi,

You have to completely close your qlikview application.

then again open qlikview.

hope this will help you.

Re: Section Access - Reduction field problem - straight from example

Tue, 04 Mar 2014 16:08:47 GMT

I know this seems ridiculous but I can't get it to stay checked. If I open the properties, check the box, apply and OK - I open the properties immediately afterward and the box is unchecked. So if I save and close and then reopen it still isn't checked and when I try using a user it doesn't reduce data so it definitely isn't working. I've copied and pasted my load script into a new document but the same problem exists.

Is there another check box somewhere I need to check/uncheck to allow me to use THIS checkbox??

Re: Section Access - Reduction field problem - straight from example

quwok — Tue, 04 Mar 2014 16:12:50 GMT

Are you logged in as an Admin user? If you are logged in as a User, you have lesser privileges which can prevent you from changing certain settings.

Re: Section Access - Reduction field problem - straight from example

Tue, 04 Mar 2014 16:15:08 GMT

Yes, I have another version of QView on my server - tested it and it works so I'm downloading the latest version of QView which will hopefully fix the problem. Very strange!

Re: Section Access - Reduction field problem - straight from example

Tue, 04 Mar 2014 16:44:06 GMT

Ok - I upgraded my QView desktop version and it now works! Must have been a bug of some description.

Thanks for your help!