topic Re: Concat() including blank values in QlikView

Concat() including blank values

Sun, 03 Aug 2014 10:15:09 GMT

Hallo QV geniuses,

As the way I see it, concat() doesn't include blank values:

I have a table like this:

when I do:

concat(A,',')

It gives me this result:

1,3

But what I want is like this:

1,,3

Is it possible?Many thanks.

Anonymous — Sun, 03 Aug 2014 10:31:25 GMT

I have just checked and it works fine for me.

Do beware though that it sorts the values so the null comes first and the output I get is :

,1,3

If you use this =concat(A,',',B) then it sorts by B and the output is :

1,,3

Sun, 03 Aug 2014 10:49:48 GMT

In excel, if you just leave it blank it will not work. But if you apply a space like pressing the space button it will work.

Space and blank values differ in concat(). Please try it in excel.

Anonymous — Sun, 03 Aug 2014 11:09:13 GMT

I do not have Excel.

Yousef_Amarneh — Sun, 03 Aug 2014 12:30:01 GMT

try this work around

maxgro — Sun, 03 Aug 2014 14:57:02 GMT

if you have an excel blank (not space) you can check it and erplace with a ''

to get 1,,3

=concat(if(len(trim(A))=0,'',A), ',', B)