topic Re: Previous Year Sale in set analysis in QlikView

Previous Year Sale in set analysis

Tue, 02 Sep 2014 09:39:14 GMT

I want to find the previous year sale for a particular day

For eg: If i am selecting 24-04-2014

I want to see the sales for 24-04-2013

I dont want to use master calendar

I want to do this in set analysis

Currently I tried this Formula

=Sum({<DATE ={<MakeDate((Year(DATE)-1),Month(DATE),Day(DATE))>}>}NET_AMOUNT)

But there is an error in this formula.

I am not good in set analysis.

Can anyone tell me whats wrong in this or how to achieve this simple in set analysis.

PrashantSangle — Tue, 02 Sep 2014 09:41:37 GMT

Hi,

Try like this,

Sum({<DATE={"$(=Date(Addmonths(DATE,-12)))"}>}NET_AMOUNT)

Sum({<DATE={"$(=Date(AddYears(DATE,-1)))"}>}NET_AMOUNT)

Regards

MK_QSL — Tue, 02 Sep 2014 09:43:43 GMT

=SUM({<TransactionDate = {'$(=MakeDate(Year(Today())-1,Month(Today()),Day(Today())))'}>}Amount)

Replace Today() with Date

Tue, 02 Sep 2014 10:03:51 GMT

Its working fine.

Thank you so much.

Can u share me the expression for MTD & YTD Calculation also

MK_QSL — Tue, 02 Sep 2014 10:08:08 GMT

YTD

=SUM({<Date= {'>=$(=YearStart(Today()))<=$(=Today())'}>}Amount)

MTD

=SUM({<Date= {'>=$(=MonthStart(Today()))<=$(=Today())'}>}Amount)

Change Date and Amount with your respective Fields....

Change Today() with your Date in case if you want to give Date selection to users...