Calculating a numbered "month of lifecycle" dimension

[#1]

Hi,

I am trying to calculate a dimension that will show the month of a customer's lifecycle.

e.g. A customer was activated on 3 April 2011. April 2011 will then become Month 1. October 2013 will be Month 31.

I have an activation date and usage periods (eg 201310), and tried to do this by:

• =((year([Usage Period]) - year([Activation Date])) * 12) + (month([Usage Period]) - month([Activation Date]))

This did not work.

I am new to QlikView and enjoying it, but this is frustrating me. Any help will be greatly appreciated.

Cheers.

[Gysbert_Wassenaar]

That's probably calculated a lot easier in the script instead of as a (slow) calculated dimension. Can you post a document with some sample data? See this document for how to do that safely: Preparing examples for Upload - Reduction and Data Scrambling