topic concat function: concatenate ALL values in QlikView

concat function: concatenate ALL values

Thu, 09 Apr 2015 07:52:45 GMT

Dear Qlikview warriors,

This should be easy

I'm trying to create a comma separated list of all Score in the table, regardless of if they are filled or not

Only Debra and John showed the courtesy to attend the test.still i want to have a list containing all scores of the class

requested result should be: ,50,,70

tried the following formula with no luck

=concat(TOTAL Score, ',', Name)

also attached example

Anonymous — Thu, 09 Apr 2015 07:58:57 GMT

use below code

=concat(if (len(Score)<1,' ', Score), ',', Name)

Thanks

BKC

Anonymous — Thu, 09 Apr 2015 08:01:53 GMT

as concat always sort resulted values so you will get it as ,,,50,70

hope this will help you .

Thanks

BKC

anbu1984 — Thu, 09 Apr 2015 08:17:34 GMT

Check this

Gabriel — Thu, 09 Apr 2015 11:21:49 GMT

Hi,

Try this

=concat(TOTAL Score, ',')

What I've done is to remove the sort weight.

jonathandienst — Thu, 09 Apr 2015 11:43:08 GMT

The other scores are nulls, so they will not be included in the Concat. You will need to change the null in the load script.

This gets all the values, but the sort order is wrong:

=concat(Aggr(If(Len(Score) = 0, '', Score), Name), ',', Name)

The sort parameter is ignored, possibly because of the Aggr() expression.