Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
lalitkgehlot89
Partner - Creator II
Partner - Creator II

Need logic help to calculate Stock Value based on AvgMovingPrice.

Hi,

In current Scenario I want to calculate Stock Value which is based on StockQty and MovingAveragePrice.

For Example.
I want to see Stock Qty and Stock Value of MaterialNo. (N350100000002) on Date 15-01-2019.

Logic for Stock Qty ----------- Sum(StockQty) where PostingDate <= 15-01-2019
Logic For Stock Value ------------ Sum(StockQty) where PostingDate <= 15-01-2019 * Material MovingAveragePrice in Jan2019

Result----------
Stock Qty---------------- 8137
Stock Value-------------- 8137 * 31.81 =258838.97

 

Please help me out to write the logic either on backend or frontend.

 

Thanks,

Lalit Kumar

Labels (2)
1 Solution

Accepted Solutions
prabir_c
Partner - Creator
Partner - Creator

Hi Lalit,

I have created a variable for Posting date and use that under chart Expression.

Please check attached.

 

View solution in original post

1 Reply
prabir_c
Partner - Creator
Partner - Creator

Hi Lalit,

I have created a variable for Posting date and use that under chart Expression.

Please check attached.