topic Re: compare current date with previous year date in QlikView

compare current date with previous year date

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

hello everyone

i have date column names as date in the format of yyyy-mm-dd

and it consist of date ranging from 2017-01-01 till today that is 2019-10-09

now i want to compare sum(sales) of today with last year

for ex:-

date | sales| lastyear| sales

2019-10-09| 500$ |2018-10-09| 800$

please help

also i dont want to use calendar script as it is complicated

i want to keep it simple like set analysis.

StarinieriG — Wed, 09 Oct 2019 07:26:44 GMT

Hi,

try to use Addyears(Today(),-1) in set analysis

riishabhz — Wed, 09 Oct 2019 07:41:06 GMT

hello sir

now date is showing of previous year but how to get sales data in it?

my column for sales data is sales

StarinieriG — Wed, 09 Oct 2019 07:44:51 GMT

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

riishabhz — Wed, 09 Oct 2019 07:52:21 GMT

sir its showing same sales data as of today.

riishabhz — Mon, 14 Oct 2019 12:12:53 GMT

i have solved it by creating 4 variables like:

currentyearstart=2019-01-01

currentyearend=2019-12-31

previousyearstart=2018-01-01

previousyearend=2018-12-31

and attached calendar to it