concat function: concatenate ALL values

[#1]

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

Name	Score
Dan
Debra	50
Dror
Fabian
John	70

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]

Hi

use below code

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

Thanks

BKC

[Anonymous]

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

hope this will help you .

Thanks

BKC

[anbu1984]

Check this

[Gabriel]

Hi,

Try this

=concat(TOTAL Score, ',')

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

[jonathandienst]

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.