Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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

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

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.