Selection in a field based on another selection

Mon, 10 Jun 2013 12:58:40 GMT

Hi guys,

I have a chart that has a list of countries (that are determined where X and Y are on a particular chart).

Example: USA has X=20 and Y= 180. This is just a visual representation of where a particular country is on my chart.
I have another list generated from a database that is a company, and within that company, it has many countries relating to it. I was wondering if there was some way that if I select that company, it would display the selected countries associated with that company.

Database looks something like:
Company Country

Company A      USA
Company A      USA
Company A      China
Company A      Mexico

Excel sheet looks something like this:
X      Y      Country name:
20   180      USA
14   -180     China
15    163     Mexico

So if I select company A, the countries USA, China, and Mexico would display.

Any help would be awesome !

Thanks!

Re: Selection in a field based on another selection

Gysbert_Wassenaar — Mon, 10 Jun 2013 13:19:58 GMT

Create a chart or straight/pivot table with Country name as dimension. Add a listbox with Company as field. As soon as you select a companie in the listbox the countries for that company will be shown in the chart or straight/pivot table.

Re: Selection in a field based on another selection

Mon, 10 Jun 2013 13:30:10 GMT

Thank you!

topic Selection in a field based on another selection in QlikView

Selection in a field based on another selection

Re: Selection in a field based on another selection

Re: Selection in a field based on another selection