Qlik Sense - dual calendars?

[#1]

Is it possible to create dual calendars (Current vs Prior) in Qlik Sense?

How best is this done - any ideas?

[abhaysingh]

Hi,

Could you please elaborate your query.. u r looking for Current vs Previous YTD ???

thanks

[#3]

Hi Abhay,

Yes, I am looking at getting YTD to work...

I want to view %Changes (Current vs Prior) etc.

Cheers

[brunobertels]

Hi Tom

This post may help you Canonical Date‌

Bruno

[abhaysingh]

You Can add this in your calender and it will work...

If( DayNumberOfYear(TempDate) <= DayNumberOfYear(Today()), 1, 0 ) as IsInYTD,

     If( DayNumberOfQuarter(TempDate) <= DayNumberOfQuarter(Today()), 1, 0) as IsInQTD,

  If( Day(TempDate) <= Day(Today()), 1, 0) as IsInMTD,

  If( Month(TempDate) = Month(Today()), 1, 0) as IsCurrentMonth,

  If( Month(AddMonths(TempDate,1)) = Month(Today()), 1, 0) as IsLastMonth,

Hope it helps....

thanks