omit doesn't work

[#1]

hi

i try the following example . and connect as user1 .

this user not have permission to see Field1 or Field2 , but for some reason he still can these fields . why ?

do i need to define something in Document level so the OMIT will work ?

thank you .

Section Access;

LOAD * INLINE [

    ACCESS, USERID, OMITGROUP

    ADMIN, admin,

    USER, user1, group1

    USER, user2, group2

];

LOAD * INLINE [

    OMITGROUP, OMIT

    group1, Field1

    group1, Field2

    group2, Field2

    group2, Field3

];

Section Application;

Fields:

LOAD * INLINE [

    Field1, Field2, Field3, Field4, Field5

    Value1, Value2, Value3, Value4, Value5

];

[sudeepkm]

have you enabled the document opening settings.

[swuehl]

You are using associative logic in your section access table (linking OMITGROUP to another table).

Honestly, I haven't tried that before. Try by joining your two tables, so you get one table for your access control.

[tresesco]

Goto Document Properties-> Opening tab -> Check 'Initial Data Reduction Based on Section Access' and 'Strict Exclusion'

[sushil353]

Hi,

Go to Settings>document properties>Opening Here check the option for " Initial data reduction based on section access"..

Save and open your qlikview again.. it should work.

HTH

Sushil

[#6]

Hi

thank you but it partial work

i try and it work for user1

but user2 still see field3

[swuehl]

Your script works for me. Field2 and Field3 are removed for user2.

Which version of QV are you using? Could you post your sample file?

[#8]

hi

i using QV version 11.00.11282

see attach qvw.

thank you

[tresesco]

I tried with:

user1- sees, Field3, Field4, Field5

user2- sees, Field4, Field5

I think that is fair. If this not what you see, probably you have to bring this into Qliktech's notice as a bug.

Note: mine is 11.2 SR3

[#10]

sorry i didn't understand what you are saying :

did you mean ?

user1- sees, Field3, Field4, Field5

user2- sees, Field4, Field5

any way according the code it should be :

user1- sees, Field3, Field4, Field5

user2- sees, Field1,Field4, Field5