Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

selimkocak
New Contributor

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
Esteemed Contributor

Re: Calculate average maturity on customer basis (sales dependent)

What is the supposed right result for this 2 lines?

Maybe?

Capture.PNG

Community Browser