Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
UserID2687
New Contributor III

Omit function in qlik sense section access

hi,

below is an section access script which i used

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;

 

Only admin and user XYZ have access to create visuals using sales_table. and ABC can able to see the table in stream once published by admin.

 

created a straight table(dimension: sales_ID and sales_date, metric-sales_count)

 

when using OMIT function in section access, whether it will hide the column(SALES_ID) in visual for user XYZ(so that XYZ can see straight table with two columns date and sales_count, but sales_ID is also implemented in that but user XYZ cant able to see in visual created by admin) or it will hide the data  in data manager(so that the user XYZ cant able to use SALES_ID dimension for creating charts)

 

 

and also  how OMIT will reflect for the user ABC in stream once the app is published

Thanks...

 

1 Solution

Accepted Solutions
UserID2687
New Contributor III

Re: Omit function in qlik sense section access

yes, i am getting invalid visualization.

I tried using the method given in below link(point 2)

https://community.qlik.com/t5/New-to-Qlik-Sense/Section-Access-OMIT-causes-Invalid-Visualisation-err...

Capture.PNG

the OMIT was applied was applied and getting correct result.

2 Replies
dwforest
Valued Contributor

Re: Omit function in qlik sense section access

Not sure if its a typo but you have sales_ID and Sales_ID... case matters
I'd also use something more different than SALES_ID vs Sales_ID, like SALES_ID_R and SALES_ID_ALL just to make it clearer.
If putting into a table you;'d have to conditionally hide it as well if the user doesn't have access to the field, otherwise the table will error with "Invalid Dimension" as it will literally be removed for those users without access.
UserID2687
New Contributor III

Re: Omit function in qlik sense section access

yes, i am getting invalid visualization.

I tried using the method given in below link(point 2)

https://community.qlik.com/t5/New-to-Qlik-Sense/Section-Access-OMIT-causes-Invalid-Visualisation-err...

Capture.PNG

the OMIT was applied was applied and getting correct result.