topic Months Calculation in QlikView https://community.qlik.com/t5/QlikView/Months-Calculation/m-p/169263#M40125 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I m using the below expression to calculate the months difference</P><P>(YEAR(RIGHT(ASOF,4))-YEAR(MID(AUTHDATE,6,4)))*12+(NUM(MONTH(date#(left(ASOF,3),'MMM')))-LEFT(AUTHDATE,2))</P><P><STRONG>DATE FORMAT:</STRONG></P><P>AUTHDATE:<BR />02APR2002:14:28:25</P><P>ASOF:<BR />SEP2008</P><P>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.</P><P>RAM: 64 GB (almost 6 to 7 Users)</P><P>pls can any one suggest</P><P>Thanks in advance.</P><P>regards,</P><P>arun</P></BODY></HTML> Wed, 03 Nov 2010 05:46:30 GMT 2010-11-03T05:46:30Z Months Calculation https://community.qlik.com/t5/QlikView/Months-Calculation/m-p/169263#M40125 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I m using the below expression to calculate the months difference</P><P>(YEAR(RIGHT(ASOF,4))-YEAR(MID(AUTHDATE,6,4)))*12+(NUM(MONTH(date#(left(ASOF,3),'MMM')))-LEFT(AUTHDATE,2))</P><P><STRONG>DATE FORMAT:</STRONG></P><P>AUTHDATE:<BR />02APR2002:14:28:25</P><P>ASOF:<BR />SEP2008</P><P>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.</P><P>RAM: 64 GB (almost 6 to 7 Users)</P><P>pls can any one suggest</P><P>Thanks in advance.</P><P>regards,</P><P>arun</P></BODY></HTML> Wed, 03 Nov 2010 05:46:30 GMT https://community.qlik.com/t5/QlikView/Months-Calculation/m-p/169263#M40125 2010-11-03T05:46:30Z