Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

retko1985
Contributor

Clicking on value will display all values based on other dimension value.

Hello,

Here is a scenario what I want to achieve in straight table:

When I select a City in Cities Listbox, It will recognize which country the city belongs to, and in straight table display all cities in this County.

So when I Click New York, In straight table it will display all cities of the USA.

Please help. Thank you.

1 Solution

Accepted Solutions
MVP
MVP

Re: Clicking on value will display all values based on other dimension value.

Check this out

Capture.PNG

Expression

Sum({<City, Country = p(Country)>}Sales)

6 Replies
MVP
MVP

Re: Clicking on value will display all values based on other dimension value.

Assuming your expression looks like this

Sum(Measure)

you need to add this set analysis

Sum({<Cities, Country = p(Country)>}Measure)

retko1985
Contributor

Re: Clicking on value will display all values based on other dimension value.

Hello,

I am not making any expressions. I just have a list of cities in straight table.

So, when I click in a Listbox with Cities it should show me in a straight table all cities in a recognized Country.

Thank you.

MVP
MVP

Re: Clicking on value will display all values based on other dimension value.

You are doing this in a straight table, right? do you have an expression in a straight table?

retko1985
Contributor

Re: Clicking on value will display all values based on other dimension value.

Yes, there are expressions. Like basic sum.

I am attaching basic example. When I select for example New York, I want to see 3 rows in straight table - New York, Seattle and Washington.

Thank you.

MVP
MVP

Re: Clicking on value will display all values based on other dimension value.

Check this out

Capture.PNG

Expression

Sum({<City, Country = p(Country)>}Sales)

retko1985
Contributor

Re: Clicking on value will display all values based on other dimension value.

Aaaaah. That was fast and amazing. Thank you...

Community Browser