topic Re: Section Access Issue in QlikView

Section Access Issue

Thu, 09 Apr 2015 11:26:55 GMT

Hello All,

I am facing issue with Section Access, I have attached source files.

Below image shows my script for section access

Whatever credentials I am using, either admin or user profile I am able to see all the data always.

I have also enabled data reduction

What might be the issue ?

Thanks in advance

Regards

Swapneel

Re: Section Access Issue

Thu, 09 Apr 2015 11:37:54 GMT

PFA

Re: Section Access Issue

marcus_malinow — Thu, 09 Apr 2015 11:46:45 GMT

Your ATTRIBUTES field is not linked to the Attributes field, therefore there is no basis for QlikView to reduce the visible data.

Add a field named ATTRIBUTES in the main part of your data and this will be used to reduce your data.

Re: Section Access Issue

PrashantSangle — Thu, 09 Apr 2015 11:47:50 GMT

Hi,

Write all in Capital Letter.

Regards

Re: Section Access Issue

Thu, 09 Apr 2015 11:56:28 GMT

hi,

Section access always works on Upper case data.

use in attributes as ATTRIBUTES and

also write it upper(attributes) as ATTRIBUTEs.

in section access gives AGE.

user1, user1

refer app.

Regards

Vimlesh

Re: Section Access Issue

Fri, 10 Apr 2015 05:03:31 GMT

hi vimlesh,

thanks for your answer but, using the same, this is what I get when I am logging in using admin credentials

where as what I expect it all the attributes to be displayed for admin, and only mentioned attributes to be displayed for

the other users.

Thanks,

Regards

Swapneel

Re: Section Access Issue

PrashantSangle — Fri, 10 Apr 2015 05:11:23 GMT

Hi,

When you said * in session acess it means it shows you only those Attributes which are mention in session Access.

If you want to show all Attributes to Admin just kept it blank.

Regards,

Re: Section Access Issue

vikasmahajan — Fri, 10 Apr 2015 05:25:59 GMT

As per MAx Deramer remove * it should help you

Vikas

Re: Section Access Issue

Fri, 10 Apr 2015 05:49:09 GMT

Dear Swapneel Golapkar,

when you will section access that time if you are giving *

* means the data whatever available in your that particular section access field only those will show.

if you want then attached more data into that field.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, ATTRIBUTE

admin,vim,vim,*

user1,vuser,vuser,AGE

user2,vuser2,vusr2,SOME

];

here if you are giving * then you will see only AGE & SOME.

if you want to see all data then put in ATTRIBUTE column like(once only)

Re: Section Access Issue

Fri, 10 Apr 2015 05:58:11 GMT

Hi,

It came to my mind of removing the * as a wild guess.

But I didnt try it. Thanks to you, it worked

Kind regards

Swapneel