topic Re: variable - Last Year returing current year in QlikView

variable - Last Year returing current year

Thu, 17 Sep 2015 20:50:31 GMT

hi!

i currently have a dataset whereby i wish to show LY and CY values.

i am struggling however with a variable that should look at the previous year same date. It returns exactly the same value as the current year.

any help is greatly appreciated.

vSetPreviousYearDay

{$<Date= {"=$(=Date(MakeDate(Max(Year) - 1, Max([Month (#)]), Day(Max(Date))),'YYYY-MM-DD'))"}
>}

=Sum($(vSetPreviousYearDay)Sales)

maxgro — Thu, 17 Sep 2015 21:02:49 GMT

maybe with AddYears, variable in bold

sum( {$<Date= {"=$(=Date(addyears(max(Date),-1),'YYYY-MM-DD'))"} >} Sales)

Thu, 17 Sep 2015 22:15:51 GMT

Thank you for your reply,

if i were to choose two dates is there a possible variable that allows for that instead of a singular day?

example - 2015-09-01 and 2015-09-02

return sum of 2014-09-01 and 2014-09-02

maxgro — Thu, 17 Sep 2015 22:31:44 GMT

maybe a union

sum(

<Date={"$(=Date(addyears(max(Date),-1),'DD/MM/YYYY'))"}>

<Date={"$(=Date(addyears(min(Date),-1),'DD/MM/YYYY'))"}>

} Sales)