Dimension level security using Section Access Qlik sense

[UserID2626]

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-err...

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...

[albert_guito]

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.