Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Selection in a field based on another selection

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!

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Selection in a field based on another selection

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.


talk is cheap, supply exceeds demand
2 Replies
MVP & Luminary
MVP & Luminary

Re: Selection in a field based on another selection

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.


talk is cheap, supply exceeds demand
Not applicable

Re: Selection in a field based on another selection

Thank you!