Discussion Board for collaboration related to QlikView App Development.
You're welcome, hope it won't affect your performance and works fine.
If there is no problem, please help to closed this questions.
And if any problem please tell me.
Zhao, could u pls explain - sign in front aggr
Sorry, what's the meaning of "sign in front aggr" ?
Do you mean the function "aggr" ?
Aggr is just a group by, it's not too hard. It just group by Month and Cost to calculate the count(cost).
minus sign before aggr function..
oops...sorry for that,
because of the firstsortedvalue, I use rank = 1, so the sort is from minus to max. But I want to get the max value, so I use the minus sign.
tnx a lot....