Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

lalitkgehlot89
Contributor 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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Need logic help to calculate Stock Value based on AvgMovingPrice.

Hi Lalit,

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

Please check attached.

 

1 Reply
Highlighted
Partner
Partner

Re: Need logic help to calculate Stock Value based on AvgMovingPrice.

Hi Lalit,

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

Please check attached.