Month on Month?

[n1ef5ng1]

Hi,

I need to generate a table that consist of two years data, YOY comparison and  MOM comparison.

My dimension is Month so it will tabulate monthly data for two years

Basicially I solved my YOY by using column 1 and 2 (2011 and 2012)

However, I am stuck in MOM as I have no idea to ask Qlikview to use Month minus Month-1 data

Any gurus can help on this?

is there such a thing of Column(2) - Column(1)-1?

[n1ef5ng1]

tried using that but failed.

is there such a thing of column(2) - column(1)-1?

am totally clueless on this now.

unable to use if else statement too...

[Gysbert_Wassenaar]

If you're using Month as dimension you can't use set analysis (without making things very very complicated). You can use an AsOf table instead. See this document. In your case all you need is a table with the month and the previous month:

MonthAsOf	Month
Jan 2012	Dec 2011
Feb 2012	Jan 2012
...etc

[n1ef5ng1]

my output is zero when i use that code.

below are my qv file,

[n1ef5ng1]

any help

[n1ef5ng1]

Hi,

I am using your method, bascially it MonthAsOf - Month to achieve the result?

However how do I create a new column for MonthAsOF

i am trying out by using Month -1 AS MonthAsOf