I am using Qlikview Server 12.0 and I have a requirement where my qvw has 3 sheets showing Cost Centers and Cost Element data . Below is the example data
Customer
Cost Center
Cost Element
Amount
A
CC100
CE10
555
B
CC200
CE20
777
C
CC100
CE20
999
Let say we have one User: USER1 and the requirement is as below:
1> In the first Sheet, USER1 should only see Cost Center CC100 and CE10 data.
2> In 2nd Sheet , USER1 should see all Cost Center data for CC100
3>In 3rd sheet , USER1 should see all Cost Element data for CE20
Is there any way , we can restrict users like this . Suggestions are welcome .