Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how can i apply sheet security in Qliksense 3.1 SRl4

Hello everyone, i have been trying to apply some rule to get security sheet in a Dashboard but i can't, someone did this before?

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hello i have resolved the security sheet with this DOC. but i can't  restrict yet with the objects like a chart or dimensions filters.

Sheet or App Object Level Security Qlik Sense

Thanks in advance.  Aehman K.

View solution in original post

8 Replies
MK9885
Master II
Master II

Anonymous
Not applicable
Author

i already  readed this likns before and dont work for me

MK9885
Master II
Master II

If you can explain where it is not working or finding trouble maybe someone can help?

Anonymous
Not applicable
Author

Well, i have Qliksense 3.1 SR4 and all the links and answer that i see about security sheet are arround 2016 versions of qliksense and i think the way to made a rule changed in this version "3.1 SR4", i don't find the selection that they make and if i write the code the syntax say error, for exmple this was a correct answer Captura.PNG

and i have somethig like this

Captura.PNG

MK9885
Master II
Master II

Yes, we have different options now.

Even I'm trying to figure it out how we can restrict either Sheet level or object based. If I get it, will reply back here.

And meantime if someone can help us on this?

vinieme12

Thanks.

MK9885
Master II
Master II

Maybe this post can help you understand more?

Security Access to Specific App Objects

Anonymous
Not applicable
Author

Hello i have resolved the security sheet with this DOC. but i can't  restrict yet with the objects like a chart or dimensions filters.

Sheet or App Object Level Security Qlik Sense

Thanks in advance.  Aehman K.

MK9885
Master II
Master II

Yes for restricting the Dimension you'd need to use OMIT in your Section Access.

https://help.qlik.com/en-US/sense/1.1/Subsystems/Hub/Content/Scripting/Security/DynamicDataReduction...

Try this below script:

Star is *;

section access;

LOAD * inline [

ACCESS, USERID,REDUCTION, OMIT

USER, DOMAIN\USERNAME,FIELD1,

USER, DOMAIN\USERNAME,FIELD2,

USER, DOMAIN\USERNAME,FIELD3,

USER, DOMAIN\USERNAME,FIELD4,

USER, DOMAIN\USERNAME,*,

USER, DOMAIN\USERNAME, *,FIELD5

USER, INTERNAL\SA_SCHEDULER,*, ///Must include this to run thru QMC

];

section application;

LOAD * INLINE [

    COUNTRY, SALES, MARGIN, PROFIT, BBB, REDUCTION

    USA, 100000, 10000, 10, CA, FIELD1

    USA, 200000, 10000, 20, AB, FIELD2

    USA, 300000, 10000, 30, BC, FIELD3

    USA, 400000, 10000, 40, CD, FIELD4

    USA, 500000, 10000, 50, QW, FIELD5

    USA, 600000, 10000, 60, BB,FIELD6

    USA, 700000, 10000, 70, ZA, FIELD7

    USA, 800000, 10000, 80, AZ, FIELD8

    USA, 900000, 90000, 90, QA, FIELD9

    USA, 100000, 10000, 10, RT, FIELD10

    ES, 110000, 11000, 110, ER, FIELD11

    ES, 120000, 12000, 120, WE, FIELD12

];

///The above script should restrict users based on Fields (Dimensions) and Values as well. You can test this in HUB