Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.