Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

New to qlikview, help required with expression

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

1 Reply
mahesh_agrawal
Creator
Creator

Can u share ur application and data???

It would be helpful in undetstanding of issue.