Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Try adding an expression on the Expression tab of the listbox: concat({1}distinct [Issue - Location],', ')
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)
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]