https://community.qlik.com/t5/QlikView/how-to-get-a-list-from-a-selection/m-p/1809592#M1212449 <P>Thank you very much !</P> Thu, 20 May 2021 22:29:53 GMT Gael31 2021-05-20T22:29:53Z https://community.qlik.com/t5/QlikView/how-to-get-a-list-from-a-selection/m-p/1809578#M1212444 <P>I have a table of type<BR />col1 col2 col3<BR />name1 note1 age2<BR />name2 note2 age1<BR />name1 note3 age3</P><P>I would like to select in the choices of col1 the value name1 to bring out in a table all the values corresponding to this thread of col2 namely note1 and note3.</P><P>Can you help me?</P> Thu, 20 May 2021 21:25:00 GMT https://community.qlik.com/t5/QlikView/how-to-get-a-list-from-a-selection/m-p/1809578#M1212444 Gael31 2021-05-20T21:25:00Z https://community.qlik.com/t5/QlikView/how-to-get-a-list-from-a-selection/m-p/1809589#M1212447 <P>The default behavior when you select 'name1' is to only display 'note1' and 'note3'.&nbsp; If you want to create a list of the available values for col2, use the&nbsp;<A href="https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/StringAggregationFunctions/concat.htm" target="_self">Concat()</A>&nbsp;function.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture3.PNG" style="width: 629px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/55429iE077E571C2798A09/image-size/large?v=v2&amp;px=999" role="button" title="Capture3.PNG" alt="Capture3.PNG" /></span></P> Thu, 20 May 2021 22:05:37 GMT https://community.qlik.com/t5/QlikView/how-to-get-a-list-from-a-selection/m-p/1809589#M1212447 jwjackso 2021-05-20T22:05:37Z https://community.qlik.com/t5/QlikView/how-to-get-a-list-from-a-selection/m-p/1809592#M1212449 <P>Thank you very much !</P> Thu, 20 May 2021 22:29:53 GMT https://community.qlik.com/t5/QlikView/how-to-get-a-list-from-a-selection/m-p/1809592#M1212449 Gael31 2021-05-20T22:29:53Z