Discussion Board for collaboration on QlikView Security and Governance.
Hi,I have a problem with section application.I have 2 filters:
In the section access:
Filter the "Pub_Company" (each ntname get permissions to different Pub_Company name)
In the section application:
Filter by tabs.(each ntname get permissions to different tabs in the document)
The Pub Company filter dosn't work:
If i filter "pub_company" for one ntname, all the other ntnames can't see the "pub_company" too.
Do you know what is the problem?
LOAD UPPER(ACCESS) AS ACCESS,
UPPER(NTNAME) AS NTNAME,
PUBCOMPANY as [Pub_Company]
(ooxml, embedded labels, table is Sheet1);
LOAD UPPER(NTNAME) AS NTNAME,
UPPER(SH01) AS SH01,
UPPER(SH02) AS SH02,
UPPER(SH03) AS SH03,
UPPER(SH04) AS SH04,
UPPER(SH05) AS SH05
LOAD * Inline [publisher_id,Pub_Company]
for access,publisher_id as user name and PASSWORD as password
for example here username as 1 and password as y1
Load * Inline