topic AW:Re: AGGR FUNCTION in QlikView

AGGR FUNCTION

Thu, 17 Feb 2011 02:57:56 GMT

Hi folks!!

I´m building accountance acumulate reports and i´ve got year and month slider´s. On a pivot table I´ve got account as dimension and four expresion columns. The way I use this reports it´s as easy as select year and month to see how profit or lose has been acumulated by the company.

It´s works fine, but now I want to create a field on a multibox that provide me some new information. I want to clasify acumulate total (depending on month selected) by account as positive or negative. To get this I wrote:

=IF(AGGR(SUM({$<MONTH={"<=MONTH"}>} IMPORT), COMPANY, ACCOUNT)>0,'POSITIVE','NEGATIVE')

I think it´s easy, but somthing is wrong. As I told before, it´s essential for me to select year and month to get data. Should be my data filtered by month? Could it be the reason to make me lose my target?

Thanks in advanced, Fiber9906

PS. I´ve read interest things, but I didn´t feel they could be my solution.

AGGR FUNCTION

maneshkhottcpl — Thu, 17 Feb 2011 03:27:01 GMT

Hi,

Please try this.

=IF(AGGR(SUM({$<MONTH={$"<=MONTH"}>} IMPORT), COMPANY, ACCOUNT)>0,'POSITIVE','NEGATIVE')

AGGR FUNCTION

Thu, 17 Feb 2011 10:59:12 GMT

Hi, thanks for your answer but it doesn´t work. It just give me 'negative' option to select. I review comas, $simbol, curly brakets,... and I think everything is ok. Any other ideas?

Thanks, Fiber9906

AGGR FUNCTION

maneshkhottcpl — Thu, 17 Feb 2011 11:54:15 GMT

Hi,

Can u post me sample application with some data?

AGGR FUNCTION

Thu, 17 Feb 2011 14:08:37 GMT

I don´t know why my computer doesn´t let me upload this document. I will prepare you my data set and explaination what it´s happening.

Thanks Manresh

Fiber9906

AW:Re: AGGR FUNCTION

brenner_martina — Thu, 17 Feb 2011 14:24:25 GMT

Hi,

best version is this:

=IF(AGGR(SUM({$<MONTH={"<=$(MONTH)"}>} IMPORT), COMPANY, ACCOUNT)>0,'POSITIVE','NEGATIVE')