topic Re: weighted average with months in QlikView https://community.qlik.com/t5/QlikView/weighted-average-with-months/m-p/735014#M475138 <HTML><HEAD></HEAD><BODY><P>I have partially solved my problem using Max(Month) - Min(Month). Partially because if Max(Month) considered has a Null QT, it is not counted in my average.. Any idea to solve this problem? thanks in advance</P></BODY></HTML> Sat, 09 Aug 2014 07:20:19 GMT 2014-08-09T07:20:19Z weighted average with months https://community.qlik.com/t5/QlikView/weighted-average-with-months/m-p/735013#M475137 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">Hi all,</SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;"> </SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">I have:</SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;"> </SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">Customer</SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">Qty</SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">Value</SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">Month</SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;"> </SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">I should calculate a weighted average of quantity starting with the month in which the Customer has been activated</SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;"> </SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">i.e </SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">Customer #1</SPAN></P><P>Month/Quantity</P><P><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">Mar: 4</SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">Sep: 7</SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">Dec:10</SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;"> </SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">My weighted average is: 2,1 [(4+7+10)/10] 10 Months because I don't count Jan+Feb when the customer did not exist. </SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">I wonder how to make it in qlik...</SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">Any suggestion would be really appreciated! Thanks in advance!</SPAN></P></BODY></HTML> Thu, 07 Aug 2014 16:59:32 GMT https://community.qlik.com/t5/QlikView/weighted-average-with-months/m-p/735013#M475137 2014-08-07T16:59:32Z Re: weighted average with months https://community.qlik.com/t5/QlikView/weighted-average-with-months/m-p/735014#M475138 <HTML><HEAD></HEAD><BODY><P>I have partially solved my problem using Max(Month) - Min(Month). Partially because if Max(Month) considered has a Null QT, it is not counted in my average.. Any idea to solve this problem? thanks in advance</P></BODY></HTML> Sat, 09 Aug 2014 07:20:19 GMT https://community.qlik.com/t5/QlikView/weighted-average-with-months/m-p/735014#M475138 2014-08-09T07:20:19Z Re: weighted average with months https://community.qlik.com/t5/QlikView/weighted-average-with-months/m-p/735015#M475139 <HTML><HEAD></HEAD><BODY><P>Please share a sample application</P></BODY></HTML> Mon, 11 Aug 2014 14:01:22 GMT https://community.qlik.com/t5/QlikView/weighted-average-with-months/m-p/735015#M475139 MarcoWedel 2014-08-11T14:01:22Z