Section Access Issue

raju_salmon — Fri, 28 Jul 2017 17:26:06 GMT

Hi,

I have an issue while implementing section access, please help me to solve this issue. Attached section access table (sheet 1 is to restrict data and sheet 2 is to restrict dashboard tabs)

I have two tabs in my dashboard, Tab 2 should be hidden to user 2 (i.e., myself), in sheet conditional option =RESTRICT i used and it is hidden when i open in my desktop (CTS\RAJU_R) however when i open in QMC, it is giving an error "Failed to open document, You don't have access to this document." I have used below script. I have done all necessary option changes in document (in document properties)

SECTION Access;

LOAD USERID,

ACCESS,

NTNAME,

STORE

FROM

[..\Data\SA Data.xlsx]

(ooxml, embedded labels, table is DBA);

SECTION Application;

LOAD USERID,

RESTRICT

FROM

[..\Data\SA Data.xlsx]

(ooxml, embedded labels, table is SheetAcces);

If i use below script it is working, but when i add second part of above script it is not working in QMC

SECTION Access;

LOAD USERID,

ACCESS,

NTNAME,

STORE

FROM

[..\Data\SA Data.xlsx]

(ooxml, embedded labels, table is DBA);

SECTION Application;

Thanks in advance for your help

Raju

Re: Section Access Issue

m_woolf — Fri, 28 Jul 2017 18:27:41 GMT

I don't know if it is related, but I get an error opening the Excel file. Excel says the file is corrupt and asks me if I want to repair it.

Re: Section Access Issue

raju_salmon — Fri, 28 Jul 2017 23:17:16 GMT

Thanks for the reply. I have tried with QVD and still it is not working.

Re: Section Access Issue

neha_shirsath — Sat, 29 Jul 2017 06:46:10 GMT

Can you resend that excel file or send your qvd because its not opening.

topic Re: Section Access Issue in QlikView

Section Access Issue

Re: Section Access Issue

Re: Section Access Issue

Re: Section Access Issue