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: 
nikita42
Partner - Contributor III
Partner - Contributor III

How to show alternate values in a table when select in field?

Hi,

I have a table like:

Case#City
1London
1

New York

1New Jersey
2Miami
2New York
2Dublin
3Mumbai
4Havana

When I select the city London, I can only see the top row as expected, but is there a way to display the other cities associated to case 1?

Basically, I need to show all cities that share a case with the selected city. So, if I select New York, I want to see all rows for Case 1 and 2, but none of the rows for case 3 and 4.

Any ideas?

1 Solution

Accepted Solutions
sunny_talwar

You can do this in a straight table using set analysis in your expression

{<City, Case# = p(Case#)>}

View solution in original post

5 Replies
sunny_talwar

You can do this in a straight table using set analysis in your expression

{<City, Case# = p(Case#)>}

nikita42
Partner - Contributor III
Partner - Contributor III
Author

Yes! Could you explain what that statement does? I've never seen it before.

sunny_talwar

It ignores selection in City field... so will disregard selection in London, but will look at all possible values of Case# based on selection in City field. So when you selected London, only possible value for Case#1, so the chart will display all cities (if city is your dimension) where Case# 1 is possible

nikita42
Partner - Contributor III
Partner - Contributor III
Author

Perfect. Thanks so much!

sunny_talwar

No problem my friend