topic Re: Restriction data by sheet in QlikView

Restriction data by sheet

Mon, 18 Feb 2013 10:32:10 GMT

Hello,

I would like to implement a restriction data by sheet on my application.

Suppose I have a table country:

Country:

France,

Espagne,

Belgique,

Suède

On The sheet 1, I would just give the access to France and Espagne.

And especially to allow the user to choose between France and Espagne in a list box.

And on the sheet 2, I want to give access to all countries.

I locked the selections in the Field Country, the user can not select from France and Espagne.

Any advice is welcome

Re: Restriction data by sheet

Gysbert_Wassenaar — Mon, 18 Feb 2013 12:45:13 GMT

If you're using QV11 you can use alternate states to achieve this. Create a new alternate state and assign it to the second sheet. See attached qvw

Re: Restriction data by sheet

Mon, 18 Feb 2013 14:21:46 GMT

Thank you for your answer,

I already use alternate state to achieve this. The problem is that the alternate state is also cleared out when I cliked on "clear all" button.

what I really want to do is :

- On a specific sheet, allow the user to have access only to France and Espagne and

allow him to select "France" or "Espagne" (in a list box)

- On another sheet, give the access to all the countries to the user.

Re: Restriction data by sheet

Gysbert_Wassenaar — Mon, 18 Feb 2013 15:49:04 GMT

Ok, that needs a bit more trickery. See attached qvw. I think it's necessary to add another field with the regions (countries in your case) that can be used to restrict the values on. That field will be locked to the restricted values.

Re: Restriction data by sheet

Mon, 18 Feb 2013 15:57:28 GMT

Yes it's excately what I needed

I'll give it a try and i'll let you know

Tnx