Undo access security on one pivot column only

hugmarcel — Thu, 23 Feb 2012 07:46:29 GMT

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

topic Undo access security on one pivot column only in QlikView

Undo access security on one pivot column only