Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

This day last year

Hi  I'm new to Qlikview, i'm trying to sum the value of transactions for yesterday date the previous year.


 


This the set analysis i use to get yesterday's figure and it works perfectly.


<SPAN style="FONT-SIZE: 10pt" mcestyle="font-size: 10pt;"><SPAN style="FONT-SIZE: 8pt" mcestyle="font-size: 8pt;">

sum({<Revenue.Date={">=$(=date(today()-1),'DD/MM/YY'))"}>} Revenue.Net) 




 


However if i apply the logic that the same day last year would be 366 days earlier it doesn't work.


<SPAN style="FONT-SIZE: 10pt" mcestyle="font-size: 10pt;"><SPAN style="FONT-SIZE: 8pt" mcestyle="font-size: 8pt;">


Does anyone have any bright ideas on how i can achieve it?



many thanks



Kate
























































































 
























































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































2 Replies
IAMDV
Honored Contributor II

Re: This day last year

Kate - I had similar requirement few months back. I mean I had to calculate Date, Month, Year for transaction data. Then I had to calculate the SameDatePrevious, SameMonthPreviousYear, PreviousMonth, PreviousYear.

I had used variables to achieve this task. Something like this...

CurrentYear = Max({1} Year)

PreviouYear = Max({1} Year) - 1

CurrentMonthNumber = Max({1<Year = {$(=$(vMaxYear))}>} MonthNumber)

PreviousMonthNumber = IF($(vCurrentMonthNumber) = 1, 12, $(vCurrentMonthNumber) - 1)

The idea is to seperate the Time dimension in to different elements like Date, Month, Year and then we use these variables within Set Analysis.

Good luck!

Cheers - DV

cesaraccardi
Valued Contributor

This day last year

Hi Kate,

Have you tried using the AddMonths(Date, -12) function? You can pass thee value -12 as the second paramenter to get the Last year date... Is that what you need?

Regards,
Cesar

Community Browser