Qlik Community

Qlik Sense App Development

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

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

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
Highlighted
Creator II
Creator II

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.

View solution in original post

3 Replies
Highlighted
Specialist II
Specialist II

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.
Highlighted
Creator II
Creator II

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.

View solution in original post

Highlighted
Contributor
Contributor

Re: Omit function in qlik sense section access

Please, could you provide the script that you wrote?