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
Try: concat({< SLA ={0}>} distinct Date, ' + ', Date)
- Marcus
Try this
Concat(DISTINCT {<SLA = {'0'}>}Date, ', ')
Thank you, both answers seem to be correct.