topic Re: Define User Specific View Grouping in QlikView

Define User Specific View Grouping

Thu, 29 Nov 2012 16:43:14 GMT

Hi all

Currently, I am sharing the qvw.file to user who will have access to view the report but they may have to focus on some specific selected value of a dimension.

For example, we have 5 materials in the fact table. User A will review 4 products, User B will review 2 products, User C will review 3 products. Is there any way to show the key figure "KG" in worksheet "Dev" according to the product list of each user?

I made the example at worksheet "Result" as the straight tables that different user can execute a button to filter out the fact table by their product list.

Thank you very much in advance.

Carmen

Re: Define User Specific View Grouping

SunilChauhan — Thu, 29 Nov 2012 17:06:38 GMT

see the attched file

hope this helps

user id are user a,user b,user c

hope this helps

Re: Define User Specific View Grouping

IAMDV — Thu, 29 Nov 2012 18:33:38 GMT

Hi,

You need to use Section Access with field Reduction. Here is the link for simple example and remember to use "Strict Exclusion" option in document properties. This option will deny the users who don't have a matching value instead of providing full access. Also attaching Section Access Tutorial.

http://community.qlik.com/message/247356#247356

Good luck! Happy learning.

I hope this helps.

Cheers,

www.QlikShare.com

Re: Define User Specific View Grouping

Fri, 30 Nov 2012 09:17:24 GMT

Hi SK

Thanks. But the qvw file is locked. Could you please unlock it?

Thanks,

Carmen

Re: Define User Specific View Grouping

SunilChauhan — Fri, 30 Nov 2012 10:25:10 GMT

use below id to unlock it

use userid

user a

user b

user c

hope this help