Expression In straight Table

[chandra63]

HI,

We want to calculate Average Expression i.e Average gap between two OD instances is 0 months

for Example we have particular Over Due(OD-Field Value) ten instance dates  like

01.01.2010,01.02.2010,01.03.2010,01.04.2010   .........01.10.2010

we want to cumulative those dates(total Days) and divide by 10  which is equal to Zero Months.

[PrashantSangle]

might be RangeAvg() will help your

https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Range...

[chandra63]

Hi Prasanth,

Thanks for  your reply.

Suppose if i am having the mindate and maxdate. How i can calculate Cumulative  of  the dates  after that  Avg  has to calulate  and convert into months

Thanks.

[PrashantSangle]

can you explain your requirement with some sample data

[chandra63]

 This is the Requirement Example.

1-Jun-17	0
1-Jul-17	30
1-Sep-17	62
1-Dec-17	91
Average	45.75
Months	1.525

Suppose i am having  6 EMI's . For 6 EMI i am having diff Dates like 

01.01.2010, 01.02.2010, 01.03.2010, 01.04.2010, 01.05.2010, 01.06.2010

paid second EMI  and fourth EMI. Remaining are Due.

so i want to  calculate remaining dates Avg like

01.01.2010     0

01.03.2010    5

01.05.2010   61

01.06.2010   31

Avg                37.75

that Avg  days has to convert to months.

thanks

[chandra63]

 This is the Requirement Example.

1-Jun-17    0

1-Jul-17     30

1-Sep-17   62

1-Dec-17   91

Avgerage   45.75

Months       1.525.

• Find out difference between 2 consecutive entries in days
• Take average of the days and convert into months

Suppose i am having  6 EMI's . For 6 EMI i am having diff Dates like 

01.01.2010, 01.02.2010, 01.03.2010, 01.04.2010, 01.05.2010, 01.06.2010

paid second EMI  and fourth EMI. Remaining are Due.

so i want to  calculate remaining dates Avg like

01.01.2010     0

01.03.2010    59

01.05.2010   61

01.06.2010   31

Avg                37.75

that Avg  days has to convert to months.

thanks

[#7]

 This is the Requirement Example.

1-Jun-17    0

1-Jul-17     30

1-Sep-17   62

1-Dec-17   91

Avgerage   45.75

Months       1.525.

• Find out difference between 2 consecutive entries in days
• Take average of the days and convert into months

Suppose i am having  6 EMI's . For 6 EMI i am having diff Dates like 

01.01.2010, 01.02.2010, 01.03.2010, 01.04.2010, 01.05.2010, 01.06.2010

paid second EMI  and fourth EMI. Remaining are Due.

so i want to  calculate remaining dates Avg like

01.01.2010     0

01.03.2010    59

01.05.2010   61

01.06.2010   31

Avg                37.75

that Avg  days has to convert to months.

thanks