How to get the value from a list box that is not selected
I need to determine the value from the Division list box in this scenario. It is not user selected, but Qlik "selects" it based on the hierarchy of the data. Is there a function that would allow me to determine the value in Division?
Cliff, did the latest post work for you? If so, be sure to come back and use the Accept as Solution button on it to give the poster credit for the assistance and let the other Community Members know it worked. If you are still trying to sort things, leave an update. Everything else I have found on the Community points to the Concat as the right solution on this one... I searched on GetPossibleValues to see those in case you want to look yourself, that is an API call, and everyone pretty much pointed to Concat as the solution.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.