https://community.qlik.com/t5/QlikView/Expression-In-straight-Table/m-p/1509446#M751772 might be RangeAvg() will help your<BR /><BR /><A href="https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/rangeavg.htm" target="_blank">https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/rangeavg.htm</A><BR /> Tue, 20 Nov 2018 05:53:33 GMT PrashantSangle 2018-11-20T05:53:33Z https://community.qlik.com/t5/QlikView/Expression-In-straight-Table/m-p/1508603#M751771 <P>HI,</P><P>We want to calculate Average Expression i.e&nbsp;<STRONG>Average gap between two OD instances is 0 months</STRONG></P><P>&nbsp;</P><P>for Example we have particular Over Due(OD-Field Value) ten instance dates&nbsp; like</P><P>01.01.2010,<SPAN>01.02.2010,01.03.2010,01.04.2010&nbsp; &nbsp;.........01.10.2010</SPAN></P><P><SPAN>we want to cumulative those dates(total Days) and divide by 10&nbsp; which is equal to Zero Months.</SPAN></P><P>&nbsp;</P> Sat, 16 Nov 2024 05:12:59 GMT https://community.qlik.com/t5/QlikView/Expression-In-straight-Table/m-p/1508603#M751771 chandra63 2024-11-16T05:12:59Z https://community.qlik.com/t5/QlikView/Expression-In-straight-Table/m-p/1509446#M751772 might be RangeAvg() will help your<BR /><BR /><A href="https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/rangeavg.htm" target="_blank">https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/rangeavg.htm</A><BR /> Tue, 20 Nov 2018 05:53:33 GMT https://community.qlik.com/t5/QlikView/Expression-In-straight-Table/m-p/1509446#M751772 PrashantSangle 2018-11-20T05:53:33Z https://community.qlik.com/t5/QlikView/Expression-In-straight-Table/m-p/1509460#M751773 <P>Hi Prasanth,</P><P>Thanks for&nbsp; your reply.</P><P>Suppose if i am having the mindate and maxdate. How i can calculate Cumulative&nbsp; of&nbsp; the dates&nbsp; after that&nbsp; Avg&nbsp; has to calulate&nbsp; and convert into months</P><P>&nbsp;</P><P>Thanks.</P> Tue, 20 Nov 2018 06:35:11 GMT https://community.qlik.com/t5/QlikView/Expression-In-straight-Table/m-p/1509460#M751773 chandra63 2018-11-20T06:35:11Z https://community.qlik.com/t5/QlikView/Expression-In-straight-Table/m-p/1509542#M751774 can you explain your requirement with some sample data Tue, 20 Nov 2018 08:55:50 GMT https://community.qlik.com/t5/QlikView/Expression-In-straight-Table/m-p/1509542#M751774 PrashantSangle 2018-11-20T08:55:50Z https://community.qlik.com/t5/QlikView/Expression-In-straight-Table/m-p/1509572#M751775 <P>&nbsp;This is the Requirement Example.</P><TABLE><TBODY><TR><TD><P>1-Jun-17</P></TD><TD><P>0</P></TD></TR><TR><TD><P>1-Jul-17</P></TD><TD><P>30</P></TD></TR><TR><TD><P>1-Sep-17</P></TD><TD><P>62</P></TD></TR><TR><TD><P>1-Dec-17</P></TD><TD><P>91</P></TD></TR><TR><TD><P>Average</P></TD><TD><P>45.75</P></TD></TR><TR><TD><P>Months</P></TD><TD><P>1.525</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P><BR /><BR /><BR /><BR />&nbsp;</P><P>Suppose i am having&nbsp; 6<STRONG>&nbsp;EMI's . </STRONG>For 6 EMI i am having diff Dates like&nbsp;</P><P>01.01.2010, 01.02.2010, 01.03.2010, 01.04.2010, 01.05.2010, 01.06.2010</P><P>paid second EMI&nbsp; and fourth EMI. Remaining are Due.</P><P>so i want to&nbsp; calculate remaining dates Avg like</P><P>01.01.2010&nbsp; &nbsp; &nbsp;0</P><P>01.03.2010&nbsp; &nbsp; 5</P><P>01.05.2010&nbsp; &nbsp;61</P><P>01.06.2010&nbsp; &nbsp;31</P><P>Avg&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 37.75</P><P>that Avg&nbsp; days has to convert to months.</P><P>&nbsp;</P><P>thanks<img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://community.qlik.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P> Tue, 20 Nov 2018 09:47:47 GMT https://community.qlik.com/t5/QlikView/Expression-In-straight-Table/m-p/1509572#M751775 chandra63 2018-11-20T09:47:47Z https://community.qlik.com/t5/QlikView/Expression-In-straight-Table/m-p/1509580#M751776 <DIV class="MinimumWidthContainer"><DIV class="min-width-wrapper"><DIV class="min-width"><DIV class="lia-content"><DIV class="lia-quilt lia-quilt-forum-topic-page lia-quilt-layout-two-column-main-side lia-top-quilt"><DIV class="lia-quilt-row lia-quilt-row-main"><DIV class="lia-quilt-column lia-quilt-column-17 lia-quilt-column-left lia-quilt-column-main-content"><DIV class="lia-quilt-column-alley lia-quilt-column-alley-left"><DIV class="lia-component-reply-list"><DIV class="linear-message-list message-list"><DIV class="lia-linear-display-message-view"><DIV class=""><DIV class="lia-panel-message message-uid-1509572"><DIV class="lia-message-view-wrapper lia-js-data-messageUid-1509572 lia-component-forums-widget-message-view-two"><DIV class="MessageView lia-message-view-forum-message lia-message-view-display lia-row-standard-read lia-thread-reply lia-message-authored-by-you"><DIV class="lia-quilt lia-quilt-forum-message lia-quilt-layout-two-column-forum-message"><DIV class="lia-quilt-row lia-quilt-row-main"><DIV class="lia-quilt-column lia-quilt-column-21 lia-quilt-column-right lia-quilt-column-main-content"><DIV class="lia-quilt-column-alley lia-quilt-column-alley-right"><DIV class="lia-message-body lia-component-body-signature-highlight-escalation"><DIV class="lia-message-body-content"><P>&nbsp;This is the Requirement Example.</P><P><SPAN>1-Jun-17&nbsp; &nbsp; 0</SPAN></P><P><SPAN>1-Jul-17&nbsp; &nbsp; &nbsp;30</SPAN></P><P><SPAN>1-Sep-17&nbsp; &nbsp;62</SPAN></P><P><SPAN>1-Dec-17&nbsp; &nbsp;91</SPAN></P><P><SPAN>Avgerage&nbsp; &nbsp;45.75</SPAN></P><P><SPAN>Months&nbsp; &nbsp; &nbsp; &nbsp;1.525.</SPAN></P><UL><LI>Find out difference between 2 consecutive entries in days</LI><LI>Take average of the days and convert into months</LI></UL><P>&nbsp;</P><P>Suppose i am having&nbsp; 6<STRONG>&nbsp;EMI's .<SPAN>&nbsp;</SPAN></STRONG>For 6 EMI i am having diff Dates like&nbsp;</P><P>01.01.2010, 01.02.2010, 01.03.2010, 01.04.2010, 01.05.2010, 01.06.2010</P><P>paid second EMI&nbsp; and fourth EMI. Remaining are Due.</P><P>so i want to&nbsp; calculate remaining dates Avg like</P><P>01.01.2010&nbsp; &nbsp; &nbsp;0</P><P>01.03.2010&nbsp; &nbsp; 59</P><P>01.05.2010&nbsp; &nbsp;61</P><P>01.06.2010&nbsp; &nbsp;31</P><P>Avg&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 37.75</P><P>that Avg&nbsp; days has to convert to months.</P><P>&nbsp;</P><P>thanks</P></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV> Tue, 20 Nov 2018 09:54:37 GMT https://community.qlik.com/t5/QlikView/Expression-In-straight-Table/m-p/1509580#M751776 chandra63 2018-11-20T09:54:37Z