topic Section Access in QlikView

Section Access

Wed, 22 Jun 2011 11:00:45 GMT

Hi,

i have the country master table and one transaction table. both of them linked based on countryid.

one country is not having transaction data.

in future it will have the transaction data.

wen i do the section access based on the country for all the users.

for example dubai has no transaction data as of now.

if i add the user1 to see only dubai data.

it should not show any data for the user1.

but in this case section access was not working, it shows all the data without restriction.

all other countries having the data,based on the restriction the application working fine.

could anyone help me to solve this issue.

thanks in advance...

Section Access

kaushiknsolanki — Wed, 22 Jun 2011 11:03:06 GMT

Hi,

Can you upload the file.

Regards,

Kaushik Solanki

Section Access

Wed, 22 Jun 2011 11:16:41 GMT

Hi Kaushik,

thanks for reply,

sorry, i cant upload the sample file....

bcoz of some restriction...

Re: Section Access

kaushiknsolanki — Wed, 22 Jun 2011 11:25:08 GMT

Hi,

Have a look at the example. (username - a, Password - a)

Here user j can c only its own data to which he is authorised. but here there is no data, so he cant see anything.

Regards,

Kaushik Solanki

Section Access

Thu, 23 Jun 2011 02:10:07 GMT

thanks for ur reply...

i have 100 companies in master table

i need to assign companies to the users

some user can see two companies data,

some of them want to see only one company.

how to assign two different companies for the two different users.

thanks in advance...

Re: Section Access

kaushiknsolanki — Thu, 23 Jun 2011 06:00:12 GMT

Hi,

All you have to do is.

Add one more line to the in your section access;

Like below.

USERID, PASSWORD, ACCESS, COMPANY

ABC, ABC, USER, XYZ

ABC, ABC, USER, PQR

Regards,

Kaushik Solanki

Section Access

Thu, 23 Jun 2011 08:30:51 GMT

thanks for response....

let me try it and tell you...