Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Show data for all companies from a country when a company is selected

I have companies as a dimension. When the user selects one company, I want to show the revenues for all the companies in the country the selected company is located in. Country is another dimension and each company has only one corresponding country attribute.

Perhaps I could have a country listbox in an alternate state, and have the corresponding country automatically be selected?

Tags (3)
1 Solution

Accepted Solutions

Re: Show data for all companies from a country when a company is selected

try something like:

=sum({<Company=,Country=p()>} Revenue)

Change the field names Company, Country and Revenue to the field names that match your situation


talk is cheap, supply exceeds demand
1 Reply

Re: Show data for all companies from a country when a company is selected

try something like:

=sum({<Company=,Country=p()>} Revenue)

Change the field names Company, Country and Revenue to the field names that match your situation


talk is cheap, supply exceeds demand
Community Browser