Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

nilesh_gangurde
Valued Contributor

Section Access

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,

];

    CODE  CODE 1
100200
100300
100400
101500
101600
102700
102800
103
104
105

Please Suggest.

-Nilesh

5 Replies
Employee
Employee

Re: Section Access

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

Bill

nilesh_gangurde
Valued Contributor

Re: Section Access

No its not working

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

Please suggest.

-Nilesh

Not applicable

Re: Section Access

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

MVP
MVP

Re: Section Access

Hi. Maybe you can try this.

Put * like Bill told, but put the line

start is *;

before the section access.

Alessandro Furtado

walidhussein
Contributor

Re: Section Access

Add this before the section access script;

star is *;

then use * for columns 103, 104 and 105

Community Browser