Section Access Issue

[#1]

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

[#2]

PFA

[marcus_malinow]

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.

[PrashantSangle]

Hi,

Write all in Capital Letter.

Regards

[#5]

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

[#6]

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

[PrashantSangle · Accepted solution]

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,

[vikasmahajan]

As per MAx Deramer remove *  it should help you

Vikas

[#9]

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)

[#10]

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