topic Months Calculation in QlikView

Months Calculation

Wed, 03 Nov 2010 05:46:32 GMT

Hi,

I m using the below expression to calculate the months difference

(YEAR(RIGHT(ASOF,4))-YEAR(MID(AUTHDATE,6,4)))*12+(NUM(MONTH(date#(left(ASOF,3),'MMM')))-LEFT(AUTHDATE,2))

DATE FORMAT:

AUTHDATE:
02APR2002:14:28:25

ASOF:
SEP2008

From the Start the Execution execution is fine, there are total 3 crore records. But in the end when it calculates the Difference i.e months using the above expression the system gets completely stuck up. almost passed 10 hrs but still its hanged.

RAM: 64 GB (almost 6 to 7 Users)

pls can any one suggest

Thanks in advance.

regards,

arun

Months Calculation

sathishkumar_go — Wed, 03 Nov 2010 06:27:52 GMT

Hi Arun,

AUTHDATE field format is 02APR2002:14:28:25

can u try this date(date#(AUTHDATE,'DDMMMYYYY HH:MM:SS'),'DD/MM/YYYY') AS AUTHDATE

ONCE U GET DATE FORMAT THEN ITS EASY

-Sathish

Months Calculation

spsrk_84 — Wed, 03 Nov 2010 06:30:16 GMT

Hi,

i have q quick question here whether you are loading the data from database or qvd?

Suppose if you are loading data from database then first fetch the data as it is i mean don't go for any calculations and store the the data in to qvd ...

then you can do the calculations while fetching the data from qvd..

Regards,

Ajay

Months Calculation

Wed, 03 Nov 2010 06:57:08 GMT

Thanks,

it really work fast !