topic Re: Aggr Function replacement in QlikView

Aggr Function replacement

polisetti — Wed, 29 Jan 2014 12:44:11 GMT

i had a issue with the data.In my db i had a split FSA ,in which for 10 FSA i have the same value .but i need to pick up only one value and it should be add to other normal FSA.I have a FLAG for Split FSA.

So i wrote

=Aggr(sum({<[Split FSA flag]={'Y'}>}[TSA Product Sales],[FSA Name]))

Sum{<[Split FSA Flag={'N'}]>}[TSA Product Sales]

It is working fine ,but instend of writing Aggr function can we write any other function.like-Only etc

Re: Aggr Function replacement

Wed, 29 Jan 2014 13:00:03 GMT

Can you have a look at comments of the thread below:

Aggr() function

Thanks,

Angad

Re: Aggr Function replacement

polisetti — Wed, 29 Jan 2014 13:05:02 GMT

The expression which i wrote is correct,and it's working fine.But instend of AGGR () is there any other function or expression that should take only one value from 10 values in split FSA

Re: Aggr Function replacement

Wed, 29 Jan 2014 13:34:06 GMT

If the values are same, try using DISTINCT keyword.