Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Partner
Partner

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?

Tags (1)
1 Solution

Accepted Solutions
Highlighted

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

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
Highlighted

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

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

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

View solution in original post

Highlighted
Partner
Partner

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

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

Highlighted

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

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

Highlighted
Partner
Partner

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

Perfect. Thanks so much!

Highlighted

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

No problem my friend