topic Display current month + previous months in QlikView

Display current month + previous months

Wed, 04 Mar 2015 06:00:17 GMT

Hello,

I am trying to do a set analysis to allow the display financial data for the last 3 months in straight table to look something like this:

Current Last Last -1

Total Expenses xx xx xx

In the expression I envisage something like this :

SUM({<$(vCurrentMonth(0))>} Amount)

SUM({<$(vCurrentMonth(-1))>} Amount)

SUM({<$(vCurrentMonth(-2))>} Amount)

I will also may want to add other criteria such as 'Account Type' = "Salaries", so thought something like this :

SUM({<$(vCurrentMonth(0)) , [Account Type] = {'Salaries'}>} Amount)

Am I on the right track, any help appreciated.

Wayne

arulsettu — Wed, 04 Mar 2015 11:48:38 GMT

try like this

SUM({<$(vCurrentMonth)-1 , [Account Type] = {'Salaries'}>} Amount)

create a variable vCurrentMonth = max(month field)

Wed, 04 Mar 2015 13:52:44 GMT

if i was you i would write an if statement something like:

Sum(If( Date > = MonthStart(Today()), Amount) as Current Month

sum(if( Date < MonthStart(Today()) and Date > = Monthstart (MonthStart(Today()) -1), Amount ) as Last Month

sum(if( Date < Monthstart (MonthStart(Today()) -1) and

Date > = MonthStart(Monthstart (MonthStart(Today()) -1) -1), Amount ) as Last-1