topic Re: binary load and section problem in QlikView

binary load and section problem

Mon, 26 Jan 2026 18:19:17 GMT

I am using binary load . when I use the section application in qvw file after binary load,I find some data missing . It is ok after reload it and then I save the qvw file and open it, the data still miss（see temp1 ). if I reload in the qvw file ,the data is ok (see temp2). what reason ?

Re: binary load and section problem

Mon, 27 Jan 2014 10:38:29 GMT

Hi Jack,

Do you have any section access to restrict access data in you qvw files ? either the source or the target one.

Fabrice

Re: binary load and section problem

amit_saini — Mon, 27 Jan 2014 10:43:32 GMT

Hi Jack,

This is because you are having section access restriction .

Thanks,

Re: binary load and section problem

sudeepkm — Mon, 27 Jan 2014 11:48:04 GMT

You may have to check your Section Access logic and fields. Section Access follows the section access table strictly that mean if in your data if you have certain field values as null or blank and that has not been taken care (to some default values) then while using section access those data could be ignored.

Re: binary load and section problem

Mon, 27 Jan 2014 12:05:41 GMT

I know section affect it . I use admin user the same. I don't use the dimension

Re: binary load and section problem

nilesh_gangurde — Mon, 27 Jan 2014 12:10:06 GMT

hi jack.

just check how mucha access u have, its fine that you are opening the document as admin.

-Nilesh

Re: binary load and section problem

sudeepkm — Mon, 27 Jan 2014 12:13:28 GMT

Can you please give the snapshot of your section access table script along with few data.

Re: binary load and section problem

Mon, 27 Jan 2014 12:57:30 GMT

the section is as following ;

SECTION ACCESS;

USER_ACCESS:

LOAD ACCESS,

USERID,

PASSWORD,

USERGROUP1,

USERGROUP2,

USERGROUP3

FROM $(DIRB)\权限用户表.xls

(biff, embedded labels, table is 用户列表$);

SUB LOADRIGHT(USERGROUP,RIGHT_NAME,RIGHT_TABLE)

SECTION APPLICATION;

STAR IS *;

$(RIGHT_TABLE):

LOAD USERGROUP as $(USERGROUP) ,

if($(RIGHT_NAME)='YES','*',$(RIGHT_NAME)) as $(RIGHT_NAME)

FROM $(DIRB)\权限用户表.xls

(biff, embedded labels, table is 分组权限$);

SECTION Application;

END Sub

Re: binary load and section problem

Mon, 27 Jan 2014 13:07:55 GMT

the data is sill missing when I open the document as admin .. I must reload and it is ok. ;I think it should not occur these data after reloading if section restrict data .

Re: binary load and section problem

jonathandienst — Mon, 27 Jan 2014 13:25:59 GMT

Section access is applied when the document is opened, and not when it is reloaded, so the data restriction will not apply immediately after a reload. So if this security is important, you will need to limit the number of people who are able to perform a reload (typically administrator(s) and the QV service account).

HTH

Jonathan

Re: Re: binary load and section problem

Tue, 28 Jan 2014 02:21:13 GMT

I think I find where the problem is . I have three group rights, for example as following:

three right dimension: area, shop(include two or more: food or book), book

when I load the QVW ，I find the food's shop data missing evenif I login as admin. if I reload it ,the data appear. The situation is the same if you reopen the qvw. This means book's right affect the other dimension's data .

How to solve this kind of rights ?