topic Re: function which returns all values of a particular field in QlikView https://community.qlik.com/t5/QlikView/function-which-returns-all-values-of-a-particular-field/m-p/840690#M295456 <HTML><HEAD></HEAD><BODY><P>That returns all possible values:</P><P></P><P>=CONCAT(DISTINCT Field, ', ')</P><P></P><P>or all values that are in the data model:</P><P><SPAN style="font-size: 13.3333330154419px;">=CONCAT({1} DISTINCT Field, ', ')</SPAN></P></BODY></HTML> Mon, 29 Jun 2015 09:10:48 GMT swuehl 2015-06-29T09:10:48Z function which returns all values of a particular field https://community.qlik.com/t5/QlikView/function-which-returns-all-values-of-a-particular-field/m-p/840688#M295454 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I need a function which returns all values of a particular field. Is it possible?</P><P></P><P>If I use GetFieldSelections it returns only those values that have been selected.</P><P></P><P>Thank you in advance,</P><P></P><P>Larisa</P></BODY></HTML> Mon, 29 Jun 2015 09:04:16 GMT https://community.qlik.com/t5/QlikView/function-which-returns-all-values-of-a-particular-field/m-p/840688#M295454 Anonymous 2015-06-29T09:04:16Z Re: function which returns all values of a particular field https://community.qlik.com/t5/QlikView/function-which-returns-all-values-of-a-particular-field/m-p/840689#M295455 <HTML><HEAD></HEAD><BODY><P>You could use concat({1} distinct Field, ',').</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 29 Jun 2015 09:10:19 GMT https://community.qlik.com/t5/QlikView/function-which-returns-all-values-of-a-particular-field/m-p/840689#M295455 marcus_sommer 2015-06-29T09:10:19Z Re: function which returns all values of a particular field https://community.qlik.com/t5/QlikView/function-which-returns-all-values-of-a-particular-field/m-p/840690#M295456 <HTML><HEAD></HEAD><BODY><P>That returns all possible values:</P><P></P><P>=CONCAT(DISTINCT Field, ', ')</P><P></P><P>or all values that are in the data model:</P><P><SPAN style="font-size: 13.3333330154419px;">=CONCAT({1} DISTINCT Field, ', ')</SPAN></P></BODY></HTML> Mon, 29 Jun 2015 09:10:48 GMT https://community.qlik.com/t5/QlikView/function-which-returns-all-values-of-a-particular-field/m-p/840690#M295456 swuehl 2015-06-29T09:10:48Z