Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
qv_jagan
Contributor

security & datamodel

I have a security model where user1 can see key1 and user2 can see both key.

Table1

UserKey
User11
User22
User21

Table2

  

UserProjectType
User1A
User2A
User2B

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.

Table3

EmployeeProject TypeKeyMeasure
100A11
100B12
101A23
101B24
102A25
102B26
103A27
103B28
104A39

One simple way to achive this is

Solution:

Combining values in Table 1 and Table 2

  Table1 & 2 -> Derived Table

UserKeyNewKey
User111A
User222A
User222B
User211A
User211B

Concatenation Project Type and Key as New Key.

Table3

  

EmployeeProject TypeKeyMeasureNewKey
100A111A
100B121B
101A232A
101B242B
102A252A
102B262B
103A272A
103B282B
104A393A

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.

Tags (1)
1 Reply
MVP & Luminary
MVP & Luminary

Re: security & datamodel

I think you've got the right idea. See this blog post: Basics for complex authorization


talk is cheap, supply exceeds demand