Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
Check the below links for the answers.
i already readed this likns before and dont work for me
If you can explain where it is not working or finding trouble maybe someone can help?
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
and i have somethig like this
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?
Thanks.
Maybe this post can help you understand more?
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.
Yes for restricting the Dimension you'd need to use OMIT in your Section Access.
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