topic Referring from aggr() to ValueList() value in QlikView

Referring from aggr() to ValueList() value

Anonymous — Sat, 04 Feb 2017 11:19:56 GMT

Hello community,

I tried to mix synthetic dimensions (Valuelist()) with calculated dimensions within a pivot,

but it doesn't work as I supposed.

LOAD * INLINE [
F1, F2
A, 1
A, 2
A, 3
B, 10
B, 20
B, 30
];

result:

expected result:

I think with the help of this construct, outstanding pivot solutions would be possible.

Regards

Robin

sunny_talwar — Sat, 04 Feb 2017 12:14:49 GMT

ValueList() cannot be used as an aggr() function's dimension.... try may be with an island table

LOAD * INLINE [

F1, F2

A, 1

A, 2

A, 3

B, 10

B, 20

B, 30

];

Dim:

LOAD * Inline [

Dim

];

and then your 2nd and 3rd dimensions will be:

Dim

=if(Dim = 'D1', 'X','Y')

Expression

If(Dim='D1', Sum(F2), RangeSum(Sum(F2),1))

swuehl — Sat, 04 Feb 2017 12:15:09 GMT

I think calculated dimensions are not possible with aggr() function.

Maybe you can use a data island field instead.

Anonymous — Sat, 04 Feb 2017 12:50:41 GMT

Thank you for your answers, that's really a pity.