topic Re: Very simple Issue but still an issue in QlikView

Very simple Issue but still an issue

Wed, 11 Mar 2015 05:37:07 GMT

I am trying to implement sestion access so when user opens file from access point , they could only see thier DIVSION,, but this does notseems to be working and i am able to everything. Please help/guide me if my code is incorrect.

SECTION Access;

LOAD Upper(NTNAME) as NTNAME,
     ACCESS,
     DIVISION
FROM
Data.xlsx
(ooxml, embedded labels, table is Security);

SECTION Application;
DATA:
LOAD DIVISION,
     [Gross Sales],
     [Net Sales]
FROM
Data.xlsx
(ooxml, embedded labels, table is DATA);

Re: Very simple Issue but still an issue

PrashantSangle — Wed, 11 Mar 2015 05:41:04 GMT

Hi,

Have you check

Setting->Document Setting->Opening->Initial Data Reduction on Session Access->check it

Regards

Re: Very simple Issue but still an issue

Anonymous — Wed, 11 Mar 2015 05:45:24 GMT

Please check the option of

Initial data reduction on section access in document properties.

Thanks,

NIshant

Re: Very simple Issue but still an issue

Wed, 11 Mar 2015 05:47:58 GMT

Damn,,, Thanks how come i forgot that.