Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tabisen1
Contributor II
Contributor II

Calculation for the next day opening stock

Dear all,

I am stuck in finding the next day opening stock. Can any one help me to do the following calculation working.

their are three table or file which I have loaded  in the QV

Loaded tables in qv.PNG

Calculation should

Opening stock + Production - Sales = Closing Stock

Closing Stock will be the opening stock for the next day. same formula for the next day this will go on day wise month or year.

Day end Closing Stock will be next Day opening Stock

Month end Closing Stock will be next month 1st day Opening Stock

Year end Closing Stock Will be next year 1st month 1st day Opening Stock

Result should look like this

Result want.PNG

18 Replies
fvelascog72
Partner - Specialist
Partner - Specialist

Can you share this data to try with it?

Or maybe a fake data with the same fields.

tabisen1
Contributor II
Contributor II
Author

i have attached the file above

fvelascog72
Partner - Specialist
Partner - Specialist

Try with this one

I hope it helps

tabisen1
Contributor II
Contributor II
Author

Federico,

If I load the excel file function not working lave a look.

tabisen1
Contributor II
Contributor II
Author

Dear Federico,

have find out the issue why is it not working by load the data through Excel.

need urgent help regarding this can you or any one else in community who can help me out from this issue.

fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

Use this:

If (OpeningQTY = '' or OpeningQTY = 0, null(), OpeningQTY)as OpeningQTY,

Cheers

tabisen1
Contributor II
Contributor II
Author

Opening stock is for the 1st day only 2nd day stock will be calculation is first day closing stock will be the opening stock for 2nd day + Receipt+issue( -ve value) equal to 2nd day close will become 3rd day opening. and so on month year ........

fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

Replace this:

If (OpeningQTY = '', null(), OpeningQTY)as OpeningQTY,

With:

If (OpeningQTY = '' or OpeningQTY = 0, null(), OpeningQTY)as OpeningQTY,
tabisen1
Contributor II
Contributor II
Author

thank you federico it works