Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lucasdavis500
Creator III
Creator III

Collapsing >1 Row In 1 Field Into 1 String

I'm looking for advice on how to collapse multiple rows from one field into a single string in a text box. I thought I had done something similar to this before, but haven't used QV in quite a while since my application was developed and I believe I removed it.

My data looks like this

Date                   SLA

1/1/2017               0

1/15/2017             0

2/1/2017               1

2/18/2017             1

I want to use a text box to show all of the dates where the field SLA is '0' separated by some delimiter

E.G.

Value in TextBox shows:

1/12017 1/15/2017

1 Solution

Accepted Solutions
sunny_talwar

Try this

Concat(DISTINCT {<SLA = {'0'}>}Date, ', ')

View solution in original post

3 Replies
marcus_sommer

Try: concat({< SLA ={0}>} distinct Date, ' + ', Date)

- Marcus

sunny_talwar

Try this

Concat(DISTINCT {<SLA = {'0'}>}Date, ', ')

lucasdavis500
Creator III
Creator III
Author

Thank you, both answers seem to be correct.