Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
lucasdavis500
Contributor II

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
Highlighted

Re: Collapsing >1 Row In 1 Field Into 1 String

Try this

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

3 Replies
MVP & Luminary
MVP & Luminary

Re: Collapsing >1 Row In 1 Field Into 1 String

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

- Marcus

Highlighted

Re: Collapsing >1 Row In 1 Field Into 1 String

Try this

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

lucasdavis500
Contributor II

Re: Collapsing >1 Row In 1 Field Into 1 String

Thank you, both answers seem to be correct.