topic Re: Putting multiple selected values in one row? in QlikView

Putting multiple selected values in one row?

Mon, 03 Feb 2014 13:53:57 GMT

Hi guys,

Is there an easy way to use something like 'SELECT STUFF ... FOR XML PATH' in SQL?

I'm trying to create a table with title like this:

Analysis for: 2014 (when one year is selected)
Analysis for: 2012, 2013, 2014 (when more than one year is selected).

I need a function that puts all selected values (ike Year in this example) and a comma between them. My current expression is:
='Analysis for: ' & Only(Year) (because I only know how to put only one value).
Can you help me?

Thanks a lot!

Re: Putting multiple selected values in one row?

jerem1234 — Mon, 03 Feb 2014 13:56:34 GMT

Use the concat function like:

='Analysis for: ' & concat(distinct Year, ',')

Or you could also use GetFieldSelections(Year)

Hope this helps!

Re: Putting multiple selected values in one row?

Mon, 03 Feb 2014 14:23:04 GMT

i agree with jerem1234´s solution

concat writes every item in the selected field (Year) after each other.

here, the function distinct is added, to prevent redundancy (2013, 2013, 2014).

The last option is the separator, which is entered between the field contents

concat(distinct Year, ',')

i would suggest to ad another space to the seperator

concat(distinct Year, ' ,')

Re: Putting multiple selected values in one row?

Mon, 03 Feb 2014 14:57:03 GMT

This certainly helps, I combined this solution with GetSelectedCount() to avoid putting all values in title when nothing is selected.

Thanks a lot for your swift answer!

Best regards,
Pawel