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

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

nikita42 — Wed, 29 Mar 2017 14:13:30 GMT

Hi,

I have a table like:

Case#	City
1	London
1	New York
1	New Jersey
2	Miami
2	New York
2	Dublin
3	Mumbai
4	Havana

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?

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

sunny_talwar — Wed, 29 Mar 2017 14:15:40 GMT

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

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

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

nikita42 — Wed, 29 Mar 2017 14:19:19 GMT

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

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

sunny_talwar — Wed, 29 Mar 2017 14:21:21 GMT

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

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

nikita42 — Wed, 29 Mar 2017 14:29:01 GMT

Perfect. Thanks so much!

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

sunny_talwar — Wed, 29 Mar 2017 14:29:39 GMT

No problem my friend