Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

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?

 

CaptureDiv.PNG

Labels (2)
2 Solutions

Accepted Solutions
Highlighted
Master II
Master II

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

Highlighted
Creator
Creator

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

Hi,

 

Use CONCAT(DISTINCT Division,  ' , ')

 

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

View solution in original post

4 Replies
Highlighted
Master II
Master II

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

Highlighted
Creator II
Creator II

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

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

Highlighted
Creator
Creator

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

Hi,

 

Use CONCAT(DISTINCT Division,  ' , ')

 

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

View solution in original post

Highlighted
Digital Support
Digital Support

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

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

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.