topic Re: Issue In Implementing Section Access in QlikView

Issue In Implementing Section Access

Fri, 10 Jan 2014 06:25:17 GMT

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

Re: Issue In Implementing Section Access

Fri, 10 Jan 2014 07:02:43 GMT

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

Re: Issue In Implementing Section Access

Fri, 10 Jan 2014 07:19:15 GMT

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..

Re: Re: Issue In Implementing Section Access

Fri, 10 Jan 2014 09:21:59 GMT

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

Re: Re: Issue In Implementing Section Access

Fri, 10 Jan 2014 09:24:58 GMT

Hi Anu,

There is no attachment.

Re: Issue In Implementing Section Access

Fri, 10 Jan 2014 09:47:53 GMT

Hi Anu,

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

Re: Issue In Implementing Section Access

Fri, 10 Jan 2014 09:50:15 GMT

Thank you

Thanks & Regards,

Anushree Shetty