topic Re: If Statement for Prior Month in QlikView

If Statement for Prior Month

JustinRamsey — Tue, 01 Sep 2020 15:34:06 GMT

I have a formula in a chart SUM({<Sales={Sales}>} if (InMonthToDate (OrderDate, Today(), 0), ValueEa)) that shows the cumulative sales of the current month. What I have been requested for is for the first 5 days of the month that value shows the prior month due to month end closing stuff. I'm stuck on this.

I am assuming I need the if statement if(day(OrderDate)<=5, NEWFORMULA, OLDFORMULA) but I am unsure of how to write the NEWFORMULA for the prior months sales. Any help would be appreciated.

Re: If Statement for Prior Month

JustinRamsey — Tue, 01 Sep 2020 15:35:05 GMT

The if statement at the bottom should be typo on my part.

if(day(today())<=5

Re: If Statement for Prior Month

Kushal_Chawda — Tue, 01 Sep 2020 15:53:41 GMT

@JustinRamsey change your new formula to below

SUM({<Sales={Sales}>} if (InMonthToDate (OrderDate, Today(), -1), ValueEa))