Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is there any options like YTD? (Year To Date)

In the Time dimension criteria, Is there any option like YTD? How to achieve it?

Regards,

Jeeva.

14 Replies
Not applicable
Author

Perumal,

              I can't see your file. Its telling "No Data to Display" & "Allocated Memory Exceeded". What shall i do for this?

Regards,

  Jeeva.

Not applicable
Author

Chriscammers,

                      Yeah, Thanks.

Regards,

Jeeva.

Not applicable
Author

Hi,

I got one application where YTD has been defined if it is useful ok

// below code will create last x year YTD sales.

Let vMonthNow = Num(MakeDate(Year(Today(1)), Month(Today(1)), 1));

Let vMonthNowLY = Num(MakeDate(Year(Today(1))-1, Month(Today(1)), 1));

Let vMonthNowL2Y = Num(MakeDate(Year(Today(1))-2, Month(Today(1)), 1));

Let vMonthNowL3Y = Num(MakeDate(Year(Today(1))-3, Month(Today(1)), 1));

Let vMonthNowL4Y = Num(MakeDate(Year(Today(1))-4, Month(Today(1)), 1));

Let vMonthNowL5Y = Num(MakeDate(Year(Today(1))-5, Month(Today(1)), 1));

Let vMonthNowL6Y = Num(MakeDate(Year(Today(1))-6, Month(Today(1)), 1));

Let vMonthNowL7Y = Num(MakeDate(Year(Today(1))-7, Month(Today(1)), 1));

Not applicable
Author

chriscammers,

How will u achieve fiscal ytd and cal ytd. Can u explain me?

Regards,

Jeeva.

Not applicable
Author

Hi,

I am sending u a file in that he has defined YTD if it is helpful k

Regards,

Rathish