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

Thu, 16 Jul 2015 14:28:41 GMT

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

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

Gysbert_Wassenaar — Thu, 16 Jul 2015 16:33:17 GMT

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.

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

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

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