topic Re: set analisys troubles in QlikView

set analisys troubles

Anonymous — Fri, 02 Nov 2012 14:05:39 GMT

Hi,

I don't know why the following expression doesn't work properly:

=aggr(sum({<MYMONTH={ "<= $(=only(PURCHASE_MONTH))"}, MY_YEAR ={"=$(CURRENTYEAR)-1)"}>} Purchase_amount), Supplier_code)

What I would have is the sum of purchase amount till the selected month (MY_MONTH), but for the previuos year (2011).

It doesn't recognize the ..{"= $(currenyear)-1).... expression. The result is nothing.

The following expression works properly

=aggr(sum({<MYMONTH={ "<= $(=only(PURCHASE_MONTH))"}, MY_YEAR ={"= $(CURRENTYEAR)"}>} Purchase_amount),Supplier_code)

I really don't understand. Help please

Thanks in advance

Re: set analisys troubles

v_iyyappan — Fri, 02 Nov 2012 14:10:14 GMT

Try like this

=aggr(sum({<MYMONTH={ "<= $(=only(PURCHASE_MONTH))"}, MY_YEAR ={"=$(AddYears(CURRENTYEAR - 1)"}>} Purchase_amount), Supplier_code)

Regards

Iyyappan

Re: set analisys troubles

CELAMBARASAN — Fri, 02 Nov 2012 14:13:40 GMT

You have DateField?If so better go with that.

Example:

=aggr(sum({<DateField={">=$(=YearStart(AddYears(Max(DateField),-1)))<=$(=AddYears(Max(DateField),-1
))"},MYMONTH=,MY_YEAR>} Purchase_amount), Supplier_code)

or based on your Expression it will be

=aggr(sum({<MYMONTH={ "<= $(=only(PURCHASE_MONTH))"}, MY_YEAR ={$(=$(CURRENTYEAR)-1))}>} Purchase_amount), Supplier_code)

Re: set analisys troubles

jonathandienst — Fri, 02 Nov 2012 14:15:54 GMT

I think this shoud work:

=Aggr(sum({<MYMONTH={"<=$(=Only(PURCHASE_MONTH))"}, MY_YEAR ={"=$(=CURRENTYEAR-1)"}>} Purchase_amount), Supplier_code)

Hope that helps

Jonathan

Re: set analisys troubles

Anonymous — Fri, 02 Nov 2012 15:03:47 GMT

Hi Iyyappan V,

it doesn't work. I get the message Error dimensions

Thanks anyway

Re: set analisys troubles

Anonymous — Fri, 02 Nov 2012 15:46:19 GMT

Thanks very much Celambarasan

and thanks to anyone has spent his time to help me.

stefan