topic Aggr in QlikView

Aggr

Tue, 27 Nov 2012 10:23:12 GMT

Hi all.

I have this table:

ID, Product, Name, Amount

001, B, AA, 150

001, B, BB, 130

002, B, CC, 170

002, B, DD, 190

and i want obtain this output:

ID, Product, Name, max(Amount)

001, B, AA, 150

002, B, CC, 170

I try to use in a table

dimension: ID, Product, Name

and expression: only(aggr(max(Amount), ID, Product, Name)

but not works.

Someone can help me?

Regards,

Marco

whiteline — Tue, 27 Nov 2012 10:54:50 GMT

Hi.

If you just want first lines you could use MinString(Amount)

Tue, 27 Nov 2012 11:04:50 GMT

no works

MayilVahanan — Tue, 27 Nov 2012 11:14:31 GMT

May be try like this

=Aggr(Max(Amount),Id)

Hope it helps

Tue, 27 Nov 2012 11:24:19 GMT

Thanks, It works!

whiteline — Tue, 27 Nov 2012 12:42:36 GMT

In this case you shoud have:

ID, Product, Name, max(Amount)

001, B, AA, 150

002, B, CC, 170 190

Tue, 27 Nov 2012 13:14:02 GMT

its working fine