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: 
bohravanraj
Partner - Creator II
Partner - Creator II

Stock inventory cuurent Value

Hello folk,

i am having a following table

itemcodeqntyitemcostdate
151010/1/2014
2101210/2/2014
151510/3/2014
151810/4/2014

and i want to generate a following report

itemcodeqntyitemcostCurrent Inventory value
11518270
21012120

the report will take the cost of maximum of date for every itemcode and should calculate inventory stock according to that code.

Thanx

1 Solution

Accepted Solutions
maxgro
MVP
MVP


Current Inventory value


FirstSortedValue(itemcost,-date) * sum(qnty)

View solution in original post

2 Replies
maxgro
MVP
MVP


Current Inventory value


FirstSortedValue(itemcost,-date) * sum(qnty)

bohravanraj
Partner - Creator II
Partner - Creator II
Author

Thanx Massimo Grossi