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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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