Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
UserID2626
Partner - Creator III
Partner - Creator 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
UserID2626
Partner - Creator III
Partner - Creator III
Author

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

4 Replies
dwforest
Specialist II
Specialist II

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.
UserID2626
Partner - Creator III
Partner - Creator III
Author

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.

zerwan
Contributor
Contributor

Please, could you provide the script that you wrote?

jp_golay
Partner - Creator II
Partner - Creator II

You can now test our new Product SAM that will fully automate Section Access Generation product.

It is no longer necessary to maintain a section access list in Excel or in your database, SAM offers you a complete web application that will secure all your data accesses.


A user can request access to an application with a simple form. Then administrators get notified and can assign the RESTRICTIONS and OMITS from the proposed fields values. User access are generated from on a single line per user, no need to generate tedious cartesian products and include all values to get a "*" value working correctly .

Moreover SAM is able to generate an automatic access section from the authorizations of the QMC, and Reverse Engineer existing section Access a time saving for simple cases.

More details on our website or contact me at jp.golay@ebiexperts.com

jp_golay_0-1639987982182.png

 

 

 

 

ebiexperts CTO
With WIP, Control everything!
Qlik Sense, QlikView and NPrinting Source control, Versioning and Deployment, Agile Lifecycle Management