Discussion Board for collaboration related to QlikView App Development.
I have a security model where user1 can see key1 and user2 can see both key.
Now I need to apply another security on top of it, where user1 can see only project type A within Key1 where are user2 can see protype A & B with key1 & key2.
Please see the data below.
One simple way to achive this is
Combining values in Table 1 and Table 2
Table1 & 2 -> Derived Table
Concatenation Project Type and Key as New Key.
Using NewKey to link Derived table & Table 3.
Can some one please let me know if there is any other want to do it.
Thanks in advance.
I think you've got the right idea. See this blog post: Basics for complex authorization