Issue In Implementing Section Access

[#1]

Hi,

I m new to qlikview, I have tried to implement section access in one of my application after having read few documents available on the net. But it does not seem to be working.So can anyone Please go through the attachment that i have provided and let me know where I am going wrong

[#2 · Accepted solution]

Hi Anushree,

Please find the attachment, It may help you.

There is small correction in script. the Userid and Access feild names should be without gap and in capital letters AND data of those fileds should be capital letter.

The other one is Section Access will be applied on only one field. Please see attached script of the document.

Santhosh G

[#3]

Hi Shetty,

LOAD * INLINE
[
DEPT,      PRODUCT,TRANSACTION,AMOUNT
SALES1,    A,      1,    124
SALES1,    B,      2,    343
SALES1,    C,  3,  4354
SALES1,    A,  4,  2445
SALES1,    B,  5,  3445
SALES1,    C,  6,  655767
SALES1,    A,  7,  3445
SALES1,    B,  8,  5654
SALES1,    C,  9,  3454
SALES1,    A,  10,  465
SALES2,    B,  11,  3435
SALES2,    C,  12,  657768
SALES2,    B,  13,  68778
SALES2,    C,  14,  65765
SALES2,    B,  15,  78665
SALES2,    C,  16,  5657
SALES2,    B,  17,  7686
SALES2,    C,  18,  565
SALES2,    B,  19,  456
SALES2,    C,  20, 540
];


Always upper Case,
QUALIFY;

SECTION ACCESS;
LOAD * INLINE [
ACCESS, USERID, PASSWORD
USER, ABC, 123
USER, DEF, 123
USER, GHI, 123
USER, JKL, 123
USER, MNO, 123
ADMIN, ADMIN, ADMIN
];
QUALIFY DEPT,PRODUCT;
SECTION APPLICATION;
LOAD * INLINE
[
USERID, DEPT,  PRODUCT
ABC,    SALES1, A
ABC, SALES1,    B
ABC, SALES1,    C
DEF, SALES2,    A
DEF, SALES2,    B
GHI, SALES1,    A
GHI, SALES2,    A
JKL, SALES2,    A
JKL, SALES2,    B
JKL, SALES2,    C
ADMIN,    *,      *
];

PFA..

[#4]

Hi Santosh,

I did try the approach that you have suggested but still i dont see the Section access security filter applied to my application.I am attaching the new application after making the changes that you have asked me to.Please have a look and let me know where i have gone wrong

[#5]

Hi Anu,

  There is no attachment.

[#6]

Hi Anu,

  Problem is you have mentioned the Access and User Id as Filed names. It should  be ACCESS and USERID

[#7]

Thank you

Thanks & Regards,

Anushree Shetty