Import Section Access Script using Include

poojask123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a section access script that is placed inside a text file [called Security.txt], which I am calling in the qlikview script using the Include statement.

$(Include=$(vpath)security.txt);

Inside the Security.txt, i have used an excel file where my actual user access is declared, the code looks like:

Section Access;

Load

UPPER(NTNAME),

UPPER(ACCESS),

UPPER(COUNTRY)

;

LOAD NTNAME,

ACCESS,

COUNTRY

FROM

(ooxml, embedded labels, table is Sheet1);

Section Application;

test:

LOAD * INLINE [

Data, COUNTRY

10, IN,

20, UK

30, AU

40, CH

50, US

60, SL

70, SG

80, OP

];

The section access doesn't seem to be working when I am calling an excel file within the txt file. But the same works if i define the user access within the txt itself and not through the XL file. Any idea how i can achieve this by still using xl file inside the txt ?

topic Import Section Access Script using Include in QlikView

Import Section Access Script using Include