Section Access removed after reload in QMC

[prma7799]

Hi All,

I am having QV Server and Publisher on different machine. I have given access of application (sales) to the one user for some tab of entire application, but when  application gets reload via QMC the user will able to see all tab .

When I am reloading application manually then user will able to see only related tabs.

Kindly advice ....

Thanks

[jyothish8807]

Hi Prama,

Can you please share your section access script ?

Also do you have strict exclusion tick in document properties ?

[jyothish8807]

On work around for time being will be to create a batch script to reload and move the .qvw to the access point.

Here is the batch file script

"C:\Program Files\QlikView\qv.exe" /R "C:\QlikviewApplications\App.qvw"

copy "C:\QlikviewApplications\App.qvw" "C:\ProgramData\QlikTech\QlikView\Documents\"

 Exit

[prma7799]

Hi KC,

you mean to say I have to tick strict exclusion, Right?

[prma7799]

Hi KC,

When i am ticking on strict exclusion then i am getting below error

[jyothish8807]

Have you added the service Account which is running the Qlik Services in the section Access sheet as ADMIN ? If no, then please add the account and try again.

Also please share your section Access script 🙂

[prma7799]

Yes Already add.

Section Access;

LOAD UPPER(NTNAME) AS NTNAME,
ACCESS
FROM
[D:\Production\Excels\SectionAccess_PNO.xlsx]
(ooxml, embedded labels, table is Sheet1);

 Section Application;

LOAD Upper(NTNAME) as NTNAME,
//GROUP,
SO1,
SO2,
SO3,
SO4,
SLS1,
SLS2,
SLS3,
SLS4,
SLS5,
SLS6,
SLS7,
SLS8,
SLS9,
SLS10,
SLS11,
CAGR,
SLS12,
SLS13,
COS,
FES,
DBP,
DBC,
DBI,
DBPR,
PCI,
PUR1,
PUR2,
PO,
OP1,
OP2,
EM1,
EM2,
EM3,
EM4,
EM5,
EM6,
EM7,
EM8,
EM9,
EM10,
BS,
PDF,
UT,
UT1,
UT2,
UT3,
UT4,
UT5,
UT6,
UT7,
MOMT,
IC,
VC,
BA,
Q1,
Q2
FROM
[D:\Production\Excels\SectionAccess.xlsx]
(ooxml, embedded labels, table is Sheet2);

[jyothish8807]

Try this logic:

https://community.qlik.com/t5/QlikView-Documents/Section-Access-Hide-Sheet-Level/ta-p/1482466?attach...

[prma7799]

Hi KC,

I have tried like above but no luck...

[pradosh_thakur]

Hi

Do you mean sheet when you say tab? To hide sheet why not use a conditional statement using
match(osuser(),field_which_conatin_user_list) or something similar.