topic Re: omit doesn't work in QlikView

omit doesn't work

Tue, 15 Oct 2013 09:01:42 GMT

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

];

Re: omit doesn't work

sudeepkm — Tue, 15 Oct 2013 09:05:38 GMT

have you enabled the document opening settings.

Re: omit doesn't work

swuehl — Tue, 15 Oct 2013 09:07:17 GMT

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.

Re: omit doesn't work

tresB — Tue, 15 Oct 2013 09:08:44 GMT

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

Re: omit doesn't work

sushil353 — Tue, 15 Oct 2013 09:10:18 GMT

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

Re: omit doesn't work

Tue, 15 Oct 2013 09:26:04 GMT

thank you but it partial work

i try and it work for user1

but user2 still see field3

Re: omit doesn't work

swuehl — Tue, 15 Oct 2013 14:24:55 GMT

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?

Re: Re: omit doesn't work

Wed, 16 Oct 2013 04:47:49 GMT

i using QV version 11.00.11282

see attach qvw.

thank you

Re: omit doesn't work

tresB — Wed, 16 Oct 2013 04:54:22 GMT

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

Re: Re: omit doesn't work

Wed, 16 Oct 2013 04:59:49 GMT

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

Re: omit doesn't work

tresB — Wed, 16 Oct 2013 05:06:24 GMT

Sorry, i should have been more careful.

Remove the JOIN and try.

Re: omit doesn't work

sudeepkm — Wed, 16 Oct 2013 05:08:05 GMT

I'm using version 11.0.11426.0 64bit and your code works fine for me.

Re: Re: omit doesn't work

Wed, 16 Oct 2013 05:16:15 GMT

maybe i missing something here.

i run the qvw via batch file , and he he ask me for user , and i insert select 'admin' .

then when i open the qvw it did not ask for user name why ?

maybe this is the problem ?

BTW : i try to do it (batch file) also with user1 an 2

Re: omit doesn't work

swuehl — Wed, 16 Oct 2013 08:45:34 GMT

What do you mean with batch file? A windows script .bat file that calls the QV executable?

How does it look like?

In principle, your code seems to work for me.

Two possible issues:

- If you want to test with different users, I believe you need to close the QV Windows application inbetween, otherwise your credentials will be remembered.

- Take care not to save the file after opening with e.g. user1, then trying to check user2. After opening with user1, your data model will be reduced to the fields allowed for user1.

If you then save and reopen with user2, only fields 3-5 are contained in your model, field3 is removed and so user2 will only see field 4 &5. That's what I see in your attached app.

--> Do a reload as admin, save the file, then don't save it again as a different user!

Re: Re: omit doesn't work

Wed, 16 Oct 2013 09:04:31 GMT

Thank you

i follow your instruction and it work good

it seem the problem was that i did not close all the open QV and sometime i save as user.

BTW : see attach how to reload via script .bat file

it is faster and do not stuck you windows applications

"C:\Program Files\QlikView\qv.exe" /r = the location where you QV exe install

"C:\SHARON\QlikView\Work_With_Permissions\bbb.qvw" = your qvw you want to run

Re: Re: omit doesn't work

Wed, 16 Oct 2013 10:19:59 GMT

after we see that it work i would like to add some restriction

I want that user1 will not see columns Field1, Field2 and will see data only his region (AA)

i try something and it didn't work for user only for admin . - see attach

do you have any idea ?

thank you

Re: Re: Re: omit doesn't work

swuehl — Wed, 16 Oct 2013 10:27:43 GMT

Your values for REGION in section access and section application don't match (AA vs AAA).

Re: Re: omit doesn't work

Wed, 16 Oct 2013 10:34:28 GMT

you right my mistake

Re: Re: omit doesn't work

Wed, 16 Oct 2013 10:39:19 GMT

yes it work for me too

thank you