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 !!
