Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

chrisjackson
New Contributor

Month to Date Yesterday

Hi

I'm trying to use a MonthToDate formula but only include up to yesterday. I thought this would be easy using the formula below, but it includes transactions from today as well. Is there something obviously wrong with the formula?

SUM({$<Date = {'>=$(=MonthStart(Today()-1))<=$(=MonthEnd(Today()-1))'}>}Sales)

Thanks

1 Solution

Accepted Solutions

Re: Month to Date Yesterday

May be this

Sum({$<Date = {'>=$(=MonthStart(Today()-1))<=$(=Date(Today()-1))'}>}Sales)

2 Replies

Re: Month to Date Yesterday

May be this

Sum({$<Date = {'>=$(=MonthStart(Today()-1))<=$(=Date(Today()-1))'}>}Sales)

Re: Month to Date Yesterday

It is absolutely correct

and why not only use today()


SUM({$<Date = {'>=$(=MonthStart(Today()-1))<=$(=Today())'}>}Sales)


Or


SUM({$<Date = {'>=$(=MonthStart(Today()-1))<=$(=Date(Today()-1))'}>}Sales)

Community Browser