topic Re: Get All Values in a Field in QlikView https://community.qlik.com/t5/QlikView/Get-All-Values-in-a-Field/m-p/389429#M484972 <HTML><HEAD></HEAD><BODY><P>Hi Adrian,</P><P></P><P>May be this one you looking for =Concat({1} Cities,',')</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Tue, 21 May 2013 05:00:36 GMT Sokkorn 2013-05-21T05:00:36Z Get All Values in a Field https://community.qlik.com/t5/QlikView/Get-All-Values-in-a-Field/m-p/389428#M484971 <HTML><HEAD></HEAD><BODY><P>Hi guys!</P><P></P><P>I'm new to QlikView and got a question here:</P><P></P><P>I have a field contain cities:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100px; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Cities</STRONG></SPAN></TH></TR><TR><TD>Jakarta</TD></TR><TR><TD>New York</TD></TR><TR><TD>Melbourne</TD></TR><TR><TD>Madrid</TD></TR><TR><TD>Tokyo</TD></TR><TR><TD>Prague</TD></TR></TBODY></TABLE><P></P><P>and I select two of them (<STRONG>New York </STRONG>and <STRONG>Melbourne</STRONG><span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100px; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Cities</STRONG></SPAN></TH></TR><TR><TD>Jakarta</TD></TR><TR><TD><SPAN style="color: #3366ff;"><STRONG>New York</STRONG></SPAN></TD></TR><TR><TD><SPAN style="color: #3366ff;"><STRONG>Melbourne</STRONG></SPAN></TD></TR><TR><TD>Madrid</TD></TR><TR><TD>Tokyo</TD></TR><TR><TD>Prague</TD></TR></TBODY></TABLE><P></P><P>I know I can get selected values using <SPAN style="font-family: 'courier new', courier;"><STRONG>GetFieldSelections() </STRONG></SPAN>function.</P><P>But how to get all field values (including selected) so that it will return (Jakarta, New York, Melbourne, Madrid, Tokyo and Prague)?</P><P>Thanks in advance!</P><P></P><P>A</P></BODY></HTML> Tue, 21 May 2013 04:57:06 GMT https://community.qlik.com/t5/QlikView/Get-All-Values-in-a-Field/m-p/389428#M484971 2013-05-21T04:57:06Z Re: Get All Values in a Field https://community.qlik.com/t5/QlikView/Get-All-Values-in-a-Field/m-p/389429#M484972 <HTML><HEAD></HEAD><BODY><P>Hi Adrian,</P><P></P><P>May be this one you looking for =Concat({1} Cities,',')</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Tue, 21 May 2013 05:00:36 GMT https://community.qlik.com/t5/QlikView/Get-All-Values-in-a-Field/m-p/389429#M484972 Sokkorn 2013-05-21T05:00:36Z Re: Get All Values in a Field https://community.qlik.com/t5/QlikView/Get-All-Values-in-a-Field/m-p/389430#M484973 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this</P><P></P><P>EX: =<SPAN style="color: #0000ff; font-size: 8pt;">Concat</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN style="font-size: 8pt;"> {1} </SPAN><SPAN style="color: #800000; font-size: 8pt;">Cities</SPAN><SPAN style="font-size: 8pt;">,',') </SPAN></P><P></P></BODY></HTML> Tue, 21 May 2013 05:01:31 GMT https://community.qlik.com/t5/QlikView/Get-All-Values-in-a-Field/m-p/389430#M484973 kumarnatarajan 2013-05-21T05:01:31Z Re: Get All Values in a Field https://community.qlik.com/t5/QlikView/Get-All-Values-in-a-Field/m-p/389431#M484974 <HTML><HEAD></HEAD><BODY><P>Thank you Sokkorn and Kumar!</P><P>Yes I want to distinct the result too.</P></BODY></HTML> Tue, 21 May 2013 05:09:32 GMT https://community.qlik.com/t5/QlikView/Get-All-Values-in-a-Field/m-p/389431#M484974 2013-05-21T05:09:32Z