topic Re: Filter Document without using section access in QlikView

Filter Document without using section access

Thu, 16 Jul 2015 09:38:32 GMT

Hi, it it possible to filter a document using the osuser() with a corresponding document ID?

eg,

I have the following lookup table :

OSUser()	DocumentUserID
mydomain/user1	smith
mydomain/user2	jones
mydomain/user3	evans
mydomain/user4	thomas
mydomain/user5	rees
mydomain/user6	hunt

In my document dataset I also have the DocumentUserID field.

Is it possible to set the DocumentUserID field depending on the value of the OSUser()??

many thanks,

Tom

Re: Filter Document without using section access

alexandros17 — Thu, 16 Jul 2015 09:40:53 GMT

Yes but it is not as safe as section access.

Re: Filter Document without using section access

Thu, 16 Jul 2015 09:47:42 GMT

Thanks for your reply.

I understand that - but I need to give the user the option of seeing all the data if required after the document is initially filtered on opening.

Do you know how to achieve this?

Re: Filter Document without using section access

Thu, 16 Jul 2015 09:59:19 GMT

Assuming you have OSUSER field in your document.

Document Properties -> Triggers -> Document Event Triggers -> OnOpen -> Add Action(s) -> Add -> Selection -> Select in Field -> OK -> OSUSER as Field -> =OSUser() as Search String

Regards,

KKR

Re: Filter Document without using section access

alexandros17 — Thu, 16 Jul 2015 10:10:37 GMT

if you need to filter data by user then test if Osuser() match with your user into your chart or your sheet.

I shuld need more details to help ypu more