List box and one to many relationships

[tinkerz1]

Hi,

If I have a one to many realtionships between a person and location, how can I make a 2 column list box show this.

=if(isnull([Issue - Location]),p({<[Issue - Location]>}),[Issue - Location])

So if 'Fred' was at 3 locations and I selected one of them, in the rest of the unselected Fred 'Location'sfield the other locataions still show.

Thanks,

Neil,

[Gysbert_Wassenaar]

Try adding an expression on the Expression tab of the listbox: concat({1}distinct [Issue - Location],', ')

[ramoncova06]

you can use this to ignore whatever you have selected and still give you the other values, though they are going to be greyed out as that is how qlikview does it filtering

=aggr(only({<Location=p({1}Location)>}Location),Location)

[tinkerz1]

Thanks, Gysbert Wassenaar very close I was trying to get a seperate line to Owner and location

Fred USA

Fred UK

Rather than Fred    UK,USA

Thanks

[tinkerz1]

I think dropping this into a expression in the general tab is really untidy solultion.

It seems I am making a unique key to stop the list box grouping.

If this is the only way, can you fixed the [location]  at a distance from the left side to make it look even and easy to see?

=[Owner]&' - '&[Location]