Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Section Access

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

1 Solution

Accepted Solutions

Re: Section Access

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  

6 Replies

Section Access

Hi,

    Can you upload the file.

Regards,

Kaushik Solanki

Not applicable

Section Access

Hi Kaushik,

thanks for reply,

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

bcoz of some restriction...

Re: Section Access

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

Not applicable

Section Access

Hi

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

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  

Not applicable

Section Access

thanks for response....

let me try it and tell you...

Community Browser