New to qlikview, help required with expression

[#1]

Hello fellow qlikers, I am very new to this and wondered if one of you would kindly help me with an expression.

Scenario

Fields:

Application date

net value

qty

material

New product indicator

No of months passed

Each material has an new product indicator 1 or 0.  What I need to do is pick out all products with a 1.

Then work out sales value for the no of months passed

Is this possible ?

examples

New product is 3 month passed. so find unit price x qty for the past three months only

New product is 5 month passed. so find unit price x qty for the past five months only.

Work out average for 3 months passed and apply to future dates on graph as a target

same for 5.

Thank you !!

[mahesh_agrawal]

Can u share ur application and data???

It would be helpful in undetstanding of issue.