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?
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.
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 *;
LOAD * inline [
ACCESS, USERID,REDUCTION, OMIT
USER, DOMAIN\USERNAME, *,FIELD5
USER, INTERNAL\SA_SCHEDULER,*, ///Must include this to run thru QMC
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