topic How to add a new calculated column? in QlikView

How to add a new calculated column?

Tue, 03 Aug 2010 08:46:25 GMT

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

How to add a new calculated column?

Miguel_Angel_Baeyens — Tue, 03 Aug 2010 08:49:54 GMT

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

How to add a new calculated column?

johnw — Wed, 04 Aug 2010 01:00:55 GMT

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.