Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
retko1985
Creator II
Creator II

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
sunny_talwar

Check this out

Capture.PNG

Expression

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

View solution in original post

6 Replies
sunny_talwar

Assuming your expression looks like this

Sum(Measure)

you need to add this set analysis

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

retko1985
Creator II
Creator II
Author

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.

sunny_talwar

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

retko1985
Creator II
Creator II
Author

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.

sunny_talwar

Check this out

Capture.PNG

Expression

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

retko1985
Creator II
Creator II
Author

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