Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
see the attched file
hope this helps
user id are user a,user b,user c
hope this helps
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,
DV
Hi SK
Thanks. But the qvw file is locked. Could you please unlock it?
Thanks,
Carmen
use below id to unlock it
use userid
user a
user b
user c
hope this help