topic Prob in Section Access in QlikView

Prob in Section Access

nikhilgarg — Mon, 02 Nov 2015 11:31:15 GMT

Hey,

I made a small application on section access but it is not working correct. Can anyone help me out?

UserName: Administrator

Psswrd: 123

Re: Prob in Section Access

Anonymous — Mon, 02 Nov 2015 11:33:22 GMT

What problem you are facing??

Re: Prob in Section Access

rubenmarin — Mon, 02 Nov 2015 11:34:56 GMT

Hi Nikhil, there is no script to check. Also, can you tell why isn't working? What are you trying to achieve?

Re: Prob in Section Access

ashfaq_haseeb — Mon, 02 Nov 2015 11:36:12 GMT

Hi,

Can you provide hidden script password as well.

And explain what is required.

Regards

ASHFAQ

Re: Prob in Section Access

nikhilgarg — Mon, 02 Nov 2015 11:59:33 GMT

hey,

username and psswrd for hidden script is admin

Re: Prob in Section Access

nikhilgarg — Mon, 02 Nov 2015 12:02:00 GMT

hey,

username and psswrd for hidden script is admin.

When i am trying to login as nikhil with psswrd, it is showing acces denied

Re: Prob in Section Access

nikhilgarg — Mon, 02 Nov 2015 12:03:06 GMT

hey,

username and psswrd for hidden script is admin.

When i am trying to login as nikhil with psswrd, it is showing acces denied

Prob in Section Access

Re: Prob in Section Access

rubenmarin — Mon, 02 Nov 2015 12:05:15 GMT

The '*' in section access only loads values loaded in the field in section access, so '*' doesn't means all values loaded in section application, if you want administrator to access all regions you can use a Join:

LOAD * Inline [

ACCESS, USERID, PASSWORD

ADMIN, ADMINISTRATOR, 123

];

Join LOAD Distinct REGION Resident TableWhereREGIONIsLoaded;

// this way Administrator is laoded with all the values in REGION, after this you can use '*' in section access and it will be related to all value (as they are previously loaded for Administrator and exists in section access)

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REGION

USER, NIKHIL, ***, NORTH

USER, USER1, *****, SOUTH

];

Re: Prob in Section Access

rubenmarin — Mon, 02 Nov 2015 12:06:41 GMT

That's beacuse you filter 'NORTH' but fields are Capitalized: 'North', so those values are different values becuase of uppercase.

Re: Prob in Section Access

nikhilgarg — Mon, 02 Nov 2015 12:09:26 GMT

Hey,

If i want admin to see all values, i can use dummy as well. But my prob here is that when i open my application, and give username as nikhil and psswrd as 123 then it is saying access denied while i have put the same username and psswrd in section access. Initially it was working fine.

Re: Prob in Section Access

nikhilgarg — Mon, 02 Nov 2015 12:12:04 GMT

Hey,

My bad. I was missing this. THanks

Re: Prob in Section Access

rubenmarin — Mon, 02 Nov 2015 12:18:35 GMT

No problem, (x*2) eyes sees more than 2 (if x>1)

Re: Prob in Section Access

Mon, 02 Nov 2015 12:21:32 GMT

HI,

The content of the link field (REGION) between the section application and access must be in upper case.