Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I ask about LAST MONTH?

I have a graph with 3 lines - Budget, Forecast, Paid (actuals) - see chart below.  For Budget and Forecast it shows the whole of the project, by month.  For Paid, I want to show just the last month I have full transactions for - "LAST MONTH".

THIS FORMULA

=If(CanonMonthYear <= Today(), RangeSum(Above(Sum(TrxnAmount), 0, RowNo())))

...It works -

   - it shows me actuals.

   - the bars stop at THIS MONTH. (April in the chart below)

I want it to stop at LAST MONTH.  How can I change "Today" to Last month?  I want the bars below to stop at March.

1 Solution

Accepted Solutions
sunny_talwar

May be like this

=If(CanonMonthYear < MonthStart(Today()), RangeSum(Above(Sum(TrxnAmount), 0, RowNo())))

View solution in original post

2 Replies
sunny_talwar

May be like this

=If(CanonMonthYear < MonthStart(Today()), RangeSum(Above(Sum(TrxnAmount), 0, RowNo())))

Not applicable
Author

THANKS!  it worked!