topic Get possible value ? in QlikView https://community.qlik.com/t5/QlikView/Get-possible-value/m-p/365731#M136059 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; I have a problem that would like to see if anyone here can help me to solve.</P><P>If I have a table, let say</P><P></P><P>ID, Department, StaffName</P><P>1,Accounting, Peter</P><P>2,Accounting, Mary</P><P>3, Accounting, David,</P><P>4, HR, Sue</P><P>5, HR, Janet</P><P></P><P>So, if I choose Department = "Accounting", I would like to store "Peter; Mary; David" into a variable, just like the output of the function GETFIELDSELECTIONS. Any idea for this if I don't want to use any macro?</P><P></P><P>If there is no choice, how the macro will be?</P><P></P><P>Thanks a lot!!!</P></BODY></HTML> Mon, 25 Jun 2012 02:40:14 GMT 2012-06-25T02:40:14Z Get possible value ? https://community.qlik.com/t5/QlikView/Get-possible-value/m-p/365731#M136059 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; I have a problem that would like to see if anyone here can help me to solve.</P><P>If I have a table, let say</P><P></P><P>ID, Department, StaffName</P><P>1,Accounting, Peter</P><P>2,Accounting, Mary</P><P>3, Accounting, David,</P><P>4, HR, Sue</P><P>5, HR, Janet</P><P></P><P>So, if I choose Department = "Accounting", I would like to store "Peter; Mary; David" into a variable, just like the output of the function GETFIELDSELECTIONS. Any idea for this if I don't want to use any macro?</P><P></P><P>If there is no choice, how the macro will be?</P><P></P><P>Thanks a lot!!!</P></BODY></HTML> Mon, 25 Jun 2012 02:40:14 GMT https://community.qlik.com/t5/QlikView/Get-possible-value/m-p/365731#M136059 2012-06-25T02:40:14Z Re: Get possible value ? https://community.qlik.com/t5/QlikView/Get-possible-value/m-p/365732#M136060 <HTML><HEAD></HEAD><BODY><P>Use <EM>concat(Department,'; ')</EM>.</P><P></P><P>Regards,</P><P>Kiran Rokkam.</P></BODY></HTML> Mon, 25 Jun 2012 03:48:57 GMT https://community.qlik.com/t5/QlikView/Get-possible-value/m-p/365732#M136060 2012-06-25T03:48:57Z Re: Get possible value ? https://community.qlik.com/t5/QlikView/Get-possible-value/m-p/365733#M136061 <HTML><HEAD></HEAD><BODY><P>Thanks Kiran.</P><P>It works!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 25 Jun 2012 06:08:45 GMT https://community.qlik.com/t5/QlikView/Get-possible-value/m-p/365733#M136061 2012-06-25T06:08:45Z