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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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

0 Replies