Use Column() in expression with aggr() and min()

[#1]

Hi All,

Is it possible to use aggr by another column in chart?

For example, get the min date with negative value in Exp1.

Something like Aggr(min(Date),Column(1), [Product Name])

Product Name	Date	Exp1	min date withe negative value
P1	01/01/15	100	02/01/15
P1	02/01/15	-20	02/01/15
P1	03/01/15	-30	02/01/15
P1	04/01/15	-50	02/01/15
P2	01/01/15	60	03/01/15
P2	02/01/15	20	03/01/15
P2	03/01/15	-30	03/01/15
P2	04/01/15	100	03/01/15

Thanks,

Almog

[Gysbert_Wassenaar]

No, you can only use field names as dimensions in the aggr function, not expressions. You could have found this information yourself in the Qlikview help file.