topic Re: Section Access in QlikView

Section Access

Mon, 26 Jan 2026 18:19:17 GMT

there is a problem

set access rights. when opening a report, data is lost, you load the script appear - save report - when opening a report, data is lost

Can you help?

security settings in the document properties are set correctly.

problem appeared not long ago

Re: Section Access

sujeetsingh — Thu, 12 Jun 2014 06:45:07 GMT

This may be due to the sheet you are loading .

try loading the sheet only without section access.

Re: Section Access

Thu, 12 Jun 2014 06:47:58 GMT

Have you make the check box Initial data reduction based on section access & Strict Exclusion from

Document Prop/Opening tab checked.

Re: Section Access

Thu, 12 Jun 2014 06:48:57 GMT

without access section, all is well

problem when it appears

Re: Section Access

Thu, 12 Jun 2014 06:51:08 GMT

here document settings

Re: Section Access

SunilChauhan — Thu, 12 Jun 2014 06:57:00 GMT

if you check then section access is doing this

check access for user how much data he have access

and if you want particular user to have all access you could write *

for Example

if user A have only EMEA access in Region field then you can writes * inplace of EMEA

it will have all region access.

hope this helps

Re: Section Access

Thu, 12 Jun 2014 07:00:20 GMT

I have is access to all the elements

Re: Section Access

Thu, 12 Jun 2014 07:01:12 GMT

Admin Override Security should also be checked if you are creating Users other than admin

and do not wanted to give some access like reloading the sheet etc.

Also try with UserID and Password instead of NTName.

Re: Section Access

Thu, 12 Jun 2014 07:04:34 GMT

for admin he should have access to all elements then just keep the field blank

on which you are applying section access

eg.

ACCESS, NTNAME, COUNTRY

ADMIN,ADMIN,

USER,USER1,US

Re: Section Access

sasikanth — Thu, 12 Jun 2014 07:04:40 GMT

HI Mariana

May be it is because of USER access that you have mentioned in Section Access table

Check with all the users once and uncheck the option initial data reduction then will find the problem

Thanks

sasi

Re: Section Access

Thu, 12 Jun 2014 07:40:46 GMT

we refer to the file

After downloading the script all is well

after opening the document, the information lost

I can not understand why cuts data when opening a document, but after loading all available

Re: Section Access

Thu, 12 Jun 2014 07:42:25 GMT

we have a slightly different system admin - one user

Re: Section Access

SergeyMak — Thu, 12 Jun 2014 07:50:33 GMT

try

STAR IS *;

before section access statement

Re: Section Access

hic — Thu, 12 Jun 2014 07:58:19 GMT

You say:

After script run, all data is there.
But after you save, and open the file, data is reduced/removed.

But this is how Section Access should work. Section Access reduces data when you open the file. But it doesn't affect what is loaded in the script run.

If you think that Section Access (after you open file) remove too much data, then you need to debug e.g. by commenting the Section Access statement (but keeping the load of the Access table). It could be a mismatch between field values in the Access table and in the real data.

HIC

Re: Section Access

Thu, 12 Jun 2014 07:58:47 GMT

do not understand where you want to put *

for example

thank you

Re: Section Access

SergeyMak — Thu, 12 Jun 2014 08:01:16 GMT

Just insert first line

STAR IS *;

before Section Access; words

Re: Section Access

hic — Thu, 12 Jun 2014 08:36:32 GMT

This will not work.

First of all, the star symbol is not very good to use as wildcard, since it will not cover all possible values. It will only match other values found in Section Access. For example, in Marina's Section Access, ЦФО can be 1 or 2. This means that the star will match these two, but it will not match 3 and 4 if these should be found in data.

Further, the demand is to reduce over two fields: БЕ and ЦФО. The demand is

(БЕ = {1,2,3} AND ЦФО = {any value}) OR (БЕ = {any value} AND ЦФО = {1,2})

but this is not how QlikView will interpret your Access table.

See more here: http://community.qlik.com/blogs/qlikviewdesignblog/2014/06/02/data-reduction-using-multiple-fields

HIC

Re: Section Access

Thu, 12 Jun 2014 08:49:36 GMT

STAR IS *;

did not help

Re: Section Access

SunilChauhan — Thu, 12 Jun 2014 08:53:09 GMT

in code

Upper(ACCESS) as ACCESS

Upper(NTNAME) as NTNAME

then apply star is *;

hope this helps

Re: Section Access

SergeyMak — Thu, 12 Jun 2014 08:56:23 GMT

I agree with http://community.qlik.com/people/hic

it shouldn't work.

Try to see http://community.qlik.com/blogs/qlikviewdesignblog/2014/06/02/data-reduction-using-multiple-fields