topic Re: Section Access in QlikView

Section Access

nilesh_gangurde — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

we are getting the following issue while using Section access. the data is as follows.

we are appliying access on the CODE Field and CODE 1 Field.

in this case we are not getting the data related to CODE 103 and 104 if we kept blank in the Inline load.

load * inline [

Access,NTNAME,CODE,CODE 1

ADMIN,XYZ,100,200

USER,PQR,100,300

USER,EFG,103,

USER,STU,104,

];

Please Suggest.

-Nilesh

Bill_Britt — Mon, 18 Nov 2013 10:24:50 GMT

Try putting a * in the code 1 column for 103, 104, 105

Bill

nilesh_gangurde — Mon, 18 Nov 2013 11:05:09 GMT

No its not working

also one more thing these two fields are not related in the Data model.

Please suggest.

-Nilesh

Wed, 27 Nov 2013 22:59:19 GMT

Nilesh could you provide us with more detail on your data model? Could you send a picture of the structure?

afurtado — Sun, 01 Dec 2013 23:08:35 GMT

Hi. Maybe you can try this.

Put * like Bill told, but put the line

start is *;

before the section access.

Alessandro Furtado

Anonymous — Sun, 01 Dec 2013 23:45:37 GMT

Add this before the section access script;

star is *;

then use * for columns 103, 104 and 105