topic Re: Hi all, aggr(concat()) problem in QlikView

Hi all, aggr(concat()) problem

Wed, 25 Jun 2014 14:03:30 GMT

Help gurus!

I do something wrong? Why value is null for 2 bottom rows?

many thx!

Re: Hi all, aggr(concat()) problem

Wed, 25 Jun 2014 14:16:30 GMT

Hi!

What result do you want to get?

Re: Hi all, aggr(concat()) problem

Gysbert_Wassenaar — Wed, 25 Jun 2014 14:17:25 GMT

I don't understand what you're trying to do. It doesn't make sense to me. What is the result you expect?

Re: Hi all, aggr(concat()) problem

maxgro — Wed, 25 Jun 2014 14:24:05 GMT

I think

aggr is by @1

@1 has 2 values

so you get a virtual table with 2 rows,

one row for @1=1 and the second for @1=2

Re: Hi all, aggr(concat()) problem

Wed, 25 Jun 2014 14:29:54 GMT

aggr is by @1 column, so its values are (1,2) then the result would be 2 rows.

If you want to have te next result:

Mark 20,333

Peter 11,11

Steve 50,231

Ilya 123

Then the aggr is by @ 2

If it helps?

Re: Hi all, aggr(concat()) problem

Wed, 25 Jun 2014 14:31:15 GMT

If it so, i think the second table sows results only for @1=1 and the third column is just hardcoded 1. So the third column (expression) can be calculated for each @2, whereas you don't have @3 values for ilya and peter, so you have nulls/ If you remove third column, NULLs will disappear

Re: Hi all, aggr(concat()) problem

Wed, 25 Jun 2014 16:52:12 GMT

Oh god sorry please, my mistake, another screen is actual, i need result:

1 Mark 11,20,231,50

1 Peter 11,20,231,50

1 Steve 11,20,231,50

2 Ilya 11,123,333

2 Mark 11,123,333

2 Peter 11,123,333

Value is a concat of all @3 group by @1, but for every @2

Re: Hi all, aggr(concat()) problem

maxgro — Wed, 25 Jun 2014 17:00:34 GMT

concat(total <@1> @3,'.')

Re: Hi all, aggr(concat()) problem

Wed, 25 Jun 2014 17:04:31 GMT

Thx!