Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

List box and one to many relationships


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.



4 Replies

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

talk is cheap, supply exceeds demand
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


Creator II
Creator II

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

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]