topic Re: Collapsing >1 Row In 1 Field Into 1 String in QlikView

Collapsing >1 Row In 1 Field Into 1 String

lucasdavis500 — Fri, 08 Dec 2017 14:27:41 GMT

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

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

marcus_sommer — Fri, 08 Dec 2017 14:32:40 GMT

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

- Marcus

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

sunny_talwar — Fri, 08 Dec 2017 14:33:24 GMT

Try this

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

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

lucasdavis500 — Fri, 08 Dec 2017 15:40:23 GMT

Thank you, both answers seem to be correct.