https://community.qlik.com/t5/App-Development/Distinct-Values-of-a-Field-in-Text-Objects/m-p/1639386#M47666 <P>Hi,</P><P>I have a requirement wherein every Division has 3 Different Departments</P><P>So when i Select a Division I want to Display each of the Department Names in Separate Text Boxes , I tried to do this using FirstSortedValue but it Does not work as it needs a numeric Sort weight is there a way to get the distinct Department names in seperate list boxes</P><P>Attached Sample app for reference</P> Thu, 24 Oct 2019 09:37:09 GMT anushree1 2019-10-24T09:37:09Z https://community.qlik.com/t5/App-Development/Distinct-Values-of-a-Field-in-Text-Objects/m-p/1639386#M47666 <P>Hi,</P><P>I have a requirement wherein every Division has 3 Different Departments</P><P>So when i Select a Division I want to Display each of the Department Names in Separate Text Boxes , I tried to do this using FirstSortedValue but it Does not work as it needs a numeric Sort weight is there a way to get the distinct Department names in seperate list boxes</P><P>Attached Sample app for reference</P> Thu, 24 Oct 2019 09:37:09 GMT https://community.qlik.com/t5/App-Development/Distinct-Values-of-a-Field-in-Text-Objects/m-p/1639386#M47666 anushree1 2019-10-24T09:37:09Z https://community.qlik.com/t5/App-Development/Distinct-Values-of-a-Field-in-Text-Objects/m-p/1639439#M47670 <P>Try these expressions</P><LI-CODE lang="markup">=SubField(Concat(DISTINCT Dept, ','), ',', 1) =SubField(Concat(DISTINCT Dept, ','), ',', 2) =SubField(Concat(DISTINCT Dept, ','), ',', 3)</LI-CODE> Thu, 24 Oct 2019 11:11:45 GMT https://community.qlik.com/t5/App-Development/Distinct-Values-of-a-Field-in-Text-Objects/m-p/1639439#M47670 sunny_talwar 2019-10-24T11:11:45Z