topic Re: Section Access on Sheet in QlikView

Section Access on Sheet

Mon, 15 Jun 2015 13:19:40 GMT

Hi All,

I'm trying to restrict sheet access using section access. But, it is not working as expected.

Below is my script. Please let me know if I'm making any mistake.

Section Access;

LOAD ACCESS,

UPPER(NTNAME) as NTNAME

FROM

[$(vDOCPath)\Tab_Access.xlsx]

(ooxml, embedded labels, table is Access);

SECTION Application;

LOAD UPPER(NTNAME) as NTNAME,

EXPORT

FROM

[$(vDOCPath)\Tab_Access.xlsx]

(ooxml, embedded labels, table is Tab);

Access table

Tab table

Thanks,

Vinod Kumar V

avinashelite — Mon, 15 Jun 2015 13:27:01 GMT

have you check the initial data reduction in the Document property >Opening ? if not do it .

Then what's your expected result ?? whats the result your getting can you please cot some words on that ?

try to add a = before the EXPORT in the conditional and then try

Anonymous — Mon, 15 Jun 2015 13:27:30 GMT

what you are getting .. Is your application asking for ID/PWD.

If not save your app and close Qlikview again open it and see if now its asking for ID/pwd or not .

Thanks

BKC

Anonymous — Mon, 15 Jun 2015 13:28:02 GMT

To restrict the sheets you don't need to use section access

=MixMatch(

osuser(),

'ADID1',

'ADID2',

)

Mon, 15 Jun 2015 13:35:36 GMT

Thanks Avinash...

I forgot enable that checkbox