topic Re: Today,YTD and MTD in Qlikview Script in QlikView

Today,YTD and MTD in Qlikview Script

Thu, 31 Jul 2014 16:33:26 GMT

Dear All,

Can any one give me Idea to find the Vaue for Today,YTD and MTD in the Qlikview Script.

Thanks In Advance !!

Regards

Deepak

Re: Today,YTD and MTD in Qlikview Script

joshabbott — Thu, 31 Jul 2014 16:35:44 GMT

Today: if(Date = Today(), True, False) as TodayDate

YTD: if(Date <= Today() and Year(Date) = Year(Today()), True, False) as YTD

MTD: if(Date <= Today() and Year(Date) = Year(Today()) and Month(Date) = Month(Today()),True, False) as MTD

Where Date is the date in your script.

Re: Today,YTD and MTD in Qlikview Script

buzzy996 — Thu, 31 Jul 2014 16:51:03 GMT

You can try:

YTD:

=num(sum({$<Year = {$(=only(Year))}, Month = {"<=$(=max(Month))"}>} LineSalesAmount), '$#,##0;($#,##0)')

QTD:

=num(sum({$<Year = {$(=only(Year))}, Quarter = {$(=only(Quarter))}, Month = {"<=$(=max(Month))"}>} LineSalesAmount), '$#,##0;($#,##0)')

MTD:

=num(sum({$} LineSalesAmount), '$#,##0;($#,##0)')

Re: Today,YTD and MTD in Qlikview Script

beunderf — Thu, 31 Jul 2014 16:54:35 GMT

What do you want to achieve with these values?

Re: Today,YTD and MTD in Qlikview Script

Thu, 31 Jul 2014 16:55:32 GMT

Hi Shiva,

I want in this Qlikview Script.

Re: Today,YTD and MTD in Qlikview Script

Thu, 31 Jul 2014 16:58:18 GMT

Hi Frank,

This is the requirement .

Re: Today,YTD and MTD in Qlikview Script

Thu, 31 Jul 2014 17:04:06 GMT

Hi Josh,

Thanks for reply. Yes Date is the Transaction Date in this Script

Re: Today,YTD and MTD in Qlikview Script

male_carrasco — Thu, 31 Jul 2014 17:06:34 GMT

Hi!

Read this:

http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd

Ale.

Re: Today,YTD and MTD in Qlikview Script

rwunderlich — Thu, 31 Jul 2014 17:07:22 GMT

Look at Help for functions:

InYearToDate()

InMonthToDate()

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Today,YTD and MTD in Qlikview Script

beunderf — Thu, 31 Jul 2014 18:59:28 GMT

Do you want to calculate these values in your load script? You want to have a fixed YTD value in a table?

Re: Today,YTD and MTD in Qlikview Script

pentaxadmin — Fri, 24 Aug 2018 13:38:16 GMT

@rwunderlich Thanks Rob - I was just looking for a similar solution. Your fx works perfect. Simple and clean.