topic Re: Qlikview Section Access in Binary Load in QlikView

Qlikview Section Access in Binary Load

Mon, 26 Jan 2026 18:19:17 GMT

Hi guys i have some question here,

i try to add inline section acces to my qlikview application which the data is binary load from other sources.

I try to add Outlet Code as a limitation, but its doesnt work. IF i change it into OMIT limitation, the script work perfectly.

can you guys help whats wrong with my script? i try to use bracket '[]' ,and '' sign on Outlet Code but nothing happened

Re: Qlikview Section Access in Binary Load

awhitfield — Fri, 15 May 2015 15:14:39 GMT

Hi,

Use [] and try changing Outlet Code to UPPER case.

HTH

Andy

Re: Qlikview Section Access in Binary Load

Fri, 15 May 2015 16:42:45 GMT

Hi Andy,

I already try using [] and change the Outlet Code into UPPER case using UPPER(Outlet Code)

but its not working, is there anything wrong with my script?

Re: Qlikview Section Access in Binary Load

Bill_Britt — Fri, 15 May 2015 19:29:36 GMT

Could it be because it is a key field.

Bill

Re: Qlikview Section Access in Binary Load

Sat, 16 May 2015 06:20:56 GMT

Hi Bill

I try to change the limitation into Location, but it doesnt work.

Arviddree

Re: Qlikview Section Access in Binary Load

manishnarang — Sat, 16 May 2015 06:41:23 GMT

Most likely reason of this not working is that in your binary load, the Location or Outlet Code might not be loaded as CAPS.

Do UPPER([Column Name]) in original application.

and do the same while loading section access in current application. Hope you already have "initial data reduction" selected already.

Best,

Manish

Re: Qlikview Section Access in Binary Load

ToniKautto — Sun, 17 May 2015 05:49:11 GMT

The Section Access is not properly defined. There must be a reduction value on each row in the section access table, the value should never be blank. The reduction for ADMIN1 and USER1 can currently be considered as undefined, and with an undefined reduction you can not really predict or have specific expectations on the reduction result.

In order to give more details advise, I would need to have some more details.

Could you please clarify what the issue symptom is?

Is the Section Access not applied?

Are users getting incorrect data?

Is user access denied?

What is the expected data for the users ADMIN1 and USER1?

Re: Qlikview Section Access in Binary Load

Peter_Cammaert — Sun, 17 May 2015 08:03:45 GMT

That's not enough. Not only do you need to link with upper case values, the name of the link field itself must be upper case as well. The Section Access area will convert Outlet Code to OUTLET CODE for you. But your data model must provide a corresponding field with an upper case-name too, otherwise they won't link and your reduction will fail...

Re: Qlikview Section Access in Binary Load

Bill_Britt — Mon, 18 May 2015 14:52:13 GMT

HI,

The service account should always be blank in section access. If not, all the data will not be reloaded.

Bill

Re: Qlikview Section Access in Binary Load

Anonymous — Mon, 18 May 2015 14:58:14 GMT

You can't use brackets within load inline. Use double quotes instead. And rename the field to "OUTLET CODE", both in section access and section application. Don't forget the upper() function in section application.

Re: Qlikview Section Access in Binary Load

ToniKautto — Mon, 18 May 2015 21:39:02 GMT

I think it depends a bit on if you use --- or not.

When strict exclusion is disabled a non-existing reduction values grants you access to all the values, which effectively will work as a wildcard. In that scenario I would prefer defining a reduction value like for example <ALL VALUES>, so that my intentions with the reduction is very clear. A blank value to me is too undefined.

Re: Qlikview Section Access in Binary Load

Bill_Britt — Tue, 19 May 2015 01:23:55 GMT

That is fine if you are only using the desktop client. If you are using publisher it can cause you issue.

A common misconception in section access is the use of “*” (star) in section access.

“Star” means “all listed values” not all values for the field. This will be explained in

detail in the script examples.

Bill

Re: Qlikview Section Access in Binary Load

Tue, 19 May 2015 03:32:58 GMT

Thanks peter, I try to change both field and section access an uppercase name, and it works.

Re: Qlikview Section Access in Binary Load

Tue, 19 May 2015 03:35:39 GMT

Thanks guys for your help, my problem is solved

i try to change my field name into upper case in data model and put OUTLET CODE in section access and now it works.

Regards,

Arviddree