topic Re: Current Year Current Month current date Vs Last Year Same Month same date Data in QlikView

Current Year Current Month current date Vs Last Year Same Month same date Data

Sat, 20 Sep 2014 07:29:03 GMT

Hi all,

I need this one

current year current month current date vs last year same month same date data

means suppose I select the 2014-sep-2 it display the sum of sales and display the same date, same month and last year means 2013-sept-2 date of the sum sales plz tell me urgent.......

Re: Current Year Current Month current date Vs Last Year Same Month same date Data

arulsettu — Sat, 20 Sep 2014 07:31:55 GMT

try this one

sum({<year={$(=max(year))}>}sales)/sum({<year={$(=max(year)-1)}>}sales)

Re: Current Year Current Month current date Vs Last Year Same Month same date Data

MK_QSL — Sat, 20 Sep 2014 08:14:56 GMT

This will give you Sum(Sales) for User Selected Date...

SUM({$<Year = , Month =, Quarter = , Date = {'$(=Max(Date))'}>}Sales)

This will give you Sum(Sales) for User Selected Date but for Last Year.. i.e if user selected 20/09/2014, you will have Sum(Sales) for 20/09/2013...

SUM({$<Year = , Month =, Quarter = , Date = {'$(=Date(AddYears(Max(Date),-1)))'}>}Sales)

Re: Current Year Current Month current date Vs Last Year Same Month same date Data

ecolomer — Sat, 20 Sep 2014 08:24:16 GMT

Here you have an example tothat

Re: Current Year Current Month current date Vs Last Year Same Month same date Data

Sat, 20 Sep 2014 08:41:35 GMT

Thanks suppose I select this 2014-aug-15 to display the sum and previous year 2014-aug-13 date sum. the condition is apply to this date its works or not plz tell me.....urgent

Re: Current Year Current Month current date Vs Last Year Same Month same date Data

Sat, 20 Sep 2014 08:46:51 GMT

Thanks suppose I select this 2014-aug-15 to display the sum and previous year 2014-aug-13 date sum. the condition apply to this date its work or not plz tell me.... urgent

Re: Current Year Current Month current date Vs Last Year Same Month same date Data

MK_QSL — Sat, 20 Sep 2014 08:49:30 GMT

SUM({$<Year = , Month =, Quarter = , Date = {'$(=Date(AddYears(Max(Date)-2,-1)))'}>}Sales)

Re: Current Year Current Month current date Vs Last Year Same Month same date Data

ecolomer — Sat, 20 Sep 2014 08:50:54 GMT

Yes, the formula is:

Sum({<YearMonth ={">=$(=Date(addmonths(Max(YearMonth), -12), 'MMM-YY')) <=$(=Date(addmonths(Max(YearMonth), -1), 'MMM-YY'))"} >} Sales)

Re: Current Year Current Month current date Vs Last Year Same Month same date Data

Sat, 20 Sep 2014 13:43:27 GMT

Hi Manish,

The last year expression sum({$<year=, month=,Quarter=, date={'$(=date(addyears(max(date),-1)))'}>}sales) is not working plz help me another one.......urgent ..plz

Re: Current Year Current Month current date Vs Last Year Same Month same date Data

mjayachandran — Sat, 20 Sep 2014 15:30:31 GMT

See this its simple.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd