Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

rajeshqvd
Contributor

Aggregation Function with in pick match

Hi,

in straight table in expression with in pick match i want to write aggr function .

egSmiley Tongueick(match(Area,ind,us,sri,pak,afg........))

Sum(sales),

sum(sales),

num(sum(aggr(sales-expens)*salesorder),0.00#),

Tags (1)
4 Replies
MVP
MVP

Re: Aggregation Function with in pick match

So is it not working? What is the issue?

rajeshqvd
Contributor

Re: Aggregation Function with in pick match

hi sunny,

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.

MVP
MVP

Re: Aggregation Function with in 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


rajeshqvd
Contributor

Re: Aggregation Function with in pick match

But my aggregation expression working fine within pick match it doesn't work

Community Browser