How to get the value from a list box that is not selected

[cliff_clayman]

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?

[m_woolf · Accepted solution]

=Division

[cliff_clayman]

Is there a way to do it if there are multiple values?

[siddheshmane · Accepted solution]

Hi,

Use CONCAT(DISTINCT Division,  ' , ')

This will concatenate all the possible values from the Division list box

[Brett_Bleess]

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.

Regards,
Brett