Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to create dual calendars (Current vs Prior) in Qlik Sense?
How best is this done - any ideas?
Hi,
Could you please elaborate your query.. u r looking for Current vs Previous YTD ???
thanks
Hi Abhay,
Yes, I am looking at getting YTD to work...
I want to view %Changes (Current vs Prior) etc.
Cheers
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