Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Qlik Sense - dual calendars?

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

How best is this done - any ideas?

4 Replies
abhaysingh
Contributor III

Re: Qlik Sense - dual calendars?

Hi,

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

thanks

Not applicable

Re: Qlik Sense - dual calendars?

Hi Abhay,

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

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

Cheers

brunobertels
Valued Contributor II

Re: Qlik Sense - dual calendars?

Hi Tom

This post may help you Canonical Date

Bruno

abhaysingh
Contributor III

Re: Qlik Sense - dual calendars?

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

Community Browser