topic Re: Today's date vs last year same date calculation in QlikView

Today's date vs last year same date calculation

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I need to calculate the sum(sales) for today's date vs last year same date.

Like today's date (2/28/2017 ) sales is 222 and i need to compare the sales for 2/28/2016

Date field: Solddate

Logic: sum(sales)

Thanks..

Re: Today's date vs last year same date calculation

Anonymous — Tue, 28 Feb 2017 16:11:12 GMT

Sum({$<Solddate={"$(=Date(AddYears(Max(Solddate), -1), 'MM/DD/YYYY'))"}>} Sales )

Re: Today's date vs last year same date calculation

Anil_Babu_Samineni — Tue, 28 Feb 2017 16:11:35 GMT

Use below condition on your Set analysis

2/28/2017

Sum({<Date = {'$(=Today())'}>}Sales)

2/28/2016

Sum({<Date = {'$(=AddYears(Today(),-1))'}>}Sales)

Re: Today's date vs last year same date calculation

nareshthavidishetty — Tue, 28 Feb 2017 16:49:31 GMT

Hi,

I need to get this as dynamic like if i select 2013 the sales is comparative in the chart like 2/28/2013 sales vs 2/28/2012.

Thanks..

Re: Today's date vs last year same date calculation

Anonymous — Tue, 28 Feb 2017 17:13:20 GMT

i think the below should be working as dynamic !!!

this year

Sum({$<Solddate={"$(=Date((Max(Solddate)), 'MM/DD/YYYY'))"}>} Sales )

previous year

Sum({$<Solddate={"$(=Date(AddYears(Max(Solddate), -1), 'MM/DD/YYYY'))"}>} Sales )

Re: Today's date vs last year same date calculation

nareshthavidishetty — Tue, 28 Feb 2017 17:43:14 GMT

Hi ,

The below logic alone is not working.

Logic: Sum({$<Solddate={"$(=Date((Max(Solddate)), 'MM/DD/YYYY'))"}>} Sales )

Thanks..

Re: Today's date vs last year same date calculation

Anonymous — Tue, 28 Feb 2017 19:22:04 GMT

may be check with your Sales , or sales , or SALES..

try to change as below ..

Sum({1<Solddate={"$(=Date((Max(Solddate)), 'MM/DD/YYYY'))"}>} sales )

Sum({1<Solddate={"$(=Date(AddYears(Max(Solddate), -1), 'MM/DD/YYYY'))"}>} sales )

hope your dimnsion should be : Solddate

Re: Today's date vs last year same date calculation

ger_alegria — Tue, 28 Feb 2017 22:09:34 GMT

You can do a master calendar from your sold date:

Load

Year(Solddate) as Year,

Month(Solddate) as Month,

Day(Solddate) as Day,

SoldDate,

Sales

From....

After That, you can use an expresion like this:

Sum({<Year = {$(max(Year))}>}Sales)

Sum({<Year = {$(max(Year)-1)}>}Sales)

Re: Today's date vs last year same date calculation

Anil_Babu_Samineni — Wed, 01 Mar 2017 02:40:59 GMT

So, Here what if you have forecast of data till November for 2017. In this case, If you select 2017 then what are expecting to see?