topic Re: Listbox with formula - automatic deselection in other listboxes? in QlikView

Listbox with formula - automatic deselection in other listboxes?

Tue, 08 May 2012 10:42:22 GMT

Our data contains Countries and Products.

The country gets selected first, then we would like to see a listbox showing only the products of that country (reason for this: access rights are per country, so products for other countries should not be visible/ selectable)

This worked fine by creating a variable (Variable_Country_Selection) and using the following formula:

if(Country=Variable_Country_Selection,Product)

This variable is set at the same tiime as the country selection (actions on a button).

But there is one big problem:

Whenever the product is deselected, the country is automatically deselected as well (and vice versa), while Variable_Country_Selection remains the same.

Example:

Country: Poland

Variable_Country_Selection: Poland

Product: Product A

If I deselect the Product, the selection changes to:

Country: no Country selected (which doesn't happen without the listbox formula)

Variable_Country_Selection: Poland

Product: no Product selected (correct)

If I deselect the Country, the selection changes to:

Country: no Country selected (correct)

Variable_Country_Selection: Poland

Product: no Product selected (which doesn't happen without the listbox formula)

Would you know a way to change a listbox to:

- show only the products of a particular country, after the country was selected

- Selection / Deselection functions normally

Thank you very much in advance for your suggestions!

Re: Listbox with formula - automatic deselection in other listboxes?

sivarajs — Tue, 08 May 2012 13:44:38 GMT

Check the sample

Re: Listbox with formula - automatic deselection in other listboxes?

jonathandienst — Tue, 08 May 2012 16:14:44 GMT

If you need confidentiality I would suggest that you use section access and data reduction. Otherwise the data is still in the QV file, and any modification, to the file, or a binary load of the file will expose the confidential information to anyone.

The manual covers this and there are many posts on this forum on using data reduction to display confidential information in a secure way to authorised users only.

Regards

Jonathan

Re: Listbox with formula - automatic deselection in other listboxes?

Anonymous — Fri, 28 Sep 2012 11:24:13 GMT

Hi Sivaraj,

i had a look at your application and it has the problem solved.

However, if you have a situation where you have more than 1 product for a customer the list of products correctly shows only the relevant items after you select a customer but when you select any of the products the other ones disappear. Any ideas how to fix this by for instance graying out the others that still apply to the customer but were not selected, please?

best regards,

Artur

Re: Listbox with formula - automatic deselection in other listboxes?

sivarajs — Fri, 28 Sep 2012 11:49:43 GMT

what you mean disappear? Can you explain or else post a sample

Re: Listbox with formula - automatic deselection in other listboxes?

Anonymous — Fri, 28 Sep 2012 12:02:15 GMT

Hi Sivaraj,

I used the sample posted by you and modified the table so now there are 2 products for customer A: xyz and ccc.

They display on your smart list ("Based on selection A") when you select customer A.

What i meant was that once you select any of the two products (e.g. xyz) the other one (ccc) disappears from the smart list and you need to click xyz again to remove selection and to be able to see them both again.

My question is: coud you have the smart list to still show ccc after selecting xyz? and not showing products related to other customers?

Many thanks for your help!

Artur