How to add a new calculated column?

[#1]

H,

I'm new to qlikview, can any one tell me how to add a new calculated column from the table.

Ex. Table has 2 columns, month & revenue. I need to add a new calculated column to calculate MOM comparison.(Current month revenue - previous month revenue)

Rgds,
Deepak

[Miguel_Angel_Baeyens]

Hello Deepak,

Depending on what chart are you creating, you may use the inter-record functions, referring MOM as, say your expression is named "Revenue", dimension "Month" is displayed horizontally on the top

[Revenue] - before([Revenue])

as expression.

Regards

[johnw]

A more complicated but I believe more robust solution is to add an extra data table that connects a given AsOfMonth to both the current Month and the previous Month. The attached example does similar, in this case comparing to data from 12 months ago instead of the previous month, but how to adjust it should be fairly obvious once you understand what the example is doing.