Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Re: How do I ask about LAST MONTH?

May be like this

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

View solution in original post

2 Replies

Re: How do I ask about LAST MONTH?

May be like this

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

View solution in original post

Not applicable

Re: How do I ask about LAST MONTH?

THANKS!  it worked!