Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
anushree1
Specialist II
Specialist II

Distinct Values of a Field in Text Objects

Hi,

I have a requirement wherein every Division has 3 Different Departments

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

Attached Sample app for reference

1 Reply
sunny_talwar

Try these expressions

=SubField(Concat(DISTINCT Dept, ','), ',', 1)
=SubField(Concat(DISTINCT Dept, ','), ',', 2)
=SubField(Concat(DISTINCT Dept, ','), ',', 3)