Discussion Board for collaboration regarding Qlik DataMarket.
in straight table in expression with in pick match i want to write aggr function .
So is it not working? What is the issue?
Thanks for your fast response.yes its doesn't work for me it showing empty cell.there is any way to use aggr function within pick match.
Your aggr() function misses the aggr() dimension list. Which fields do you want to use to group by your expression results in the aggr() function? Area? City? Area & City?
sum(aggr(Sum(sales-expens), Area, City)*salesorder)
Probably not the correct solution, but best I can guess with the information provided
Pitfalls of the Aggr function
But my aggregation expression working fine within pick match it doesn't work