Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
tinkerz1
Creator II
Creator II

List box and one to many relationships

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,

4 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
ramoncova06
Specialist III
Specialist III

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
Creator II
Creator II
Author

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
Creator II
Creator II
Author


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]