Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
hugmarcel
Specialist
Specialist

Undo access security on one pivot column only

I have a security table in the script, let say:

SECTION access;
SELECT
QV_ACCESS AS "ACCESS",
QV_SERIAL AS SERIAL,
WINDOWS_NTNAME AS NTNAME,            
QV_USERID AS USERID,
QV_PASSWORD AS PASSWORD,
EMPLOYEE_SEC,
FROM <my security table>;

section application;

Field EMPLOYEE_SEC is linked to a column of my application data model, where it filters employee data.

How is it possible to deactivate the security filter in one pivot column formula only? E.g.:

= count({$ <EMPLOYEE_SEC = >} DISTINCT employees)

does not seem to work.

Thx - Marcel

Labels (1)
0 Replies