topic Re: set analysis problem in QlikView

set analysis problem

Wed, 05 Mar 2014 10:52:00 GMT

hi, my problem in when i select year=2014 and month=1, i want to get saleQty in year=2013 and month=1(last year current month saleQty). pls help

Re: set analysis problem

MK_QSL — Wed, 05 Mar 2014 10:58:53 GMT

SUM({<Year = {'$(=Max(Year)-1)'}>}saleQty)

Re: set analysis problem

Wed, 05 Mar 2014 11:02:34 GMT

thanks manish. I missed the Max(). why we use Max() for that?

Re: set analysis problem

MK_QSL — Wed, 05 Mar 2014 11:05:40 GMT

In case if you have selected 2 or 3 years at a time, we need to tell set analysis that the calculation need to be based on Max Year from the selected.

Re: set analysis problem

Wed, 05 Mar 2014 11:06:46 GMT

hi, the result is same as 2014. it s not changing to 2013

Re: set analysis problem

Wed, 05 Mar 2014 11:08:17 GMT

No manish, i m only selecting one year at a time. then i want to get last year saleQty

Re: set analysis problem

jagan — Wed, 05 Mar 2014 11:10:24 GMT

Hi,

If you have date dimension then try like this

=Sum({<YearDimensionName=, QuarterDimensionName=, MonthDimensionName=,

DateDimensionName={'>=$(=MonthStart(Max(DateDimensionName), -12))<=$(=MonthEnd(Max(DateDimensionName), -12))'}>} Sales)

Regards,

jagan.

Re: set analysis problem

Wed, 05 Mar 2014 11:15:28 GMT

Hi jagan, I only have year and month. for an example when i select year=2014 and month=1, i want to get saleQty in year=2013 and month=1(last year current month saleQty). my fields are year, month, saleQty

Re: Re: set analysis problem

MK_QSL — Wed, 05 Mar 2014 11:15:38 GMT

Check enclosed file...

Re: set analysis problem

Wed, 05 Mar 2014 11:21:41 GMT

thanks both of u