Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section Access

hi

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

19 Replies
Not applicable
Author

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

Not applicable
Author

we have a slightly different system admin - one user

SergeyMak
Partner Ambassador
Partner Ambassador

try

STAR IS *;

before section access statement

Regards,
Sergey
hic
Former Employee
Former Employee

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.

See also http://community.qlik.com/blogs/qlikviewdesignblog/2014/05/26/section-access

HIC

Not applicable
Author

do not understand where you want to put *

for example

thank you

SergeyMak
Partner Ambassador
Partner Ambassador

Just insert first line

STAR IS *;

before Section Access; words

Regards,
Sergey
hic
Former Employee
Former Employee

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

Not applicable
Author

STAR IS *;

did not help

SunilChauhan
Champion
Champion

in code

Upper(ACCESS) as ACCESS

Upper(NTNAME) as NTNAME

then apply star is *;

hope this helps

Sunil Chauhan
SergeyMak
Partner Ambassador
Partner Ambassador