Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
selimkocak
Contributor II
Contributor II

Calculate average maturity on customer basis (sales dependent)

Hello there,

I would like to take the average grade of customer-based futures sales bills as in the case of excel in the trade.

Thanks in advance for your help

sample

  

customer ID    date    maturity    sales

20434307    6.01.2017    5.07.2017    115

20434307    6.01.2017    8.01.2017    339

(maturity * sales / total(sales) ) ,custumerID

stalwar1

1 Reply
OmarBenSalem
Partner - Champion II
Partner - Champion II

What is the supposed right result for this 2 lines?

Maybe?

Capture.PNG