Dimension level security using Section Access Qlik sense

UserID2626 — Sat, 16 Nov 2024 21:18:04 GMT

hi,

I am implementing section access for dimension level using OMIT function.

Section Access:

LOAD * INLINE[

USER,ACCESS,OMIT

ADMIN,INTERNAL\SA_SCHEDULER,

USER,DOMAIN\ADMIN,

USER,DOMAIN\XYZ,SALES_ID

USER,DOMAIN\ABC,SALES_ID

];

Section Application;

Load

Sales_date,

Sales_ID,

Sales_count

from Sales_table;

OMIT function was applied and i got invalid visualization , then followed the 2nd point given in below link and got result

https://community.qlik.com/t5/New-to-Qlik-Sense/Section-Access-OMIT-causes-Invalid-Visualisation-error/td-p/8302

but i am getting null value for which OMIT was applied.

is there is way to hide the column SALES_ID from the user whom i need to hide.

Thanks...

Re: Dimension level security using Section Access Qlik sense

albert_guito — Wed, 06 Mar 2019 07:19:23 GMT

Maybe you can create a flag table:

Load * Inline [Flag
0
1
];

And reduce in the secction access the value to 0 or 1 by user as you need.

To show or hide the column you can use a conditional function like Sum({1} Flag)=0 for example. So when reduction gets 1 the column will be hidden.

topic Re: Dimension level security using Section Access Qlik sense in App Development

Dimension level security using Section Access Qlik sense

Re: Dimension level security using Section Access Qlik sense