Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Partner
Partner

Re: Calculation for the next day opening stock

Can you share this data to try with it?

Or maybe a fake data with the same fields.

Highlighted
tabisen1
New Contributor

Re: Calculation for the next day opening stock

i have attached the file above

Partner
Partner

Re: Calculation for the next day opening stock

Try with this one

I hope it helps

tabisen1
New Contributor

Re: Calculation for the next day opening stock

Federico,

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

tabisen1
New Contributor

Re: Calculation for the next day opening stock

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.

Partner
Partner

Re: Calculation for the next day opening stock

Hi,

Use this:

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

Cheers

tabisen1
New Contributor

Re: Calculation for the next day opening stock

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

Partner
Partner

Re: Calculation for the next day opening stock

Hi,

Replace this:

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

With:

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

View solution in original post

tabisen1
New Contributor

Re: Calculation for the next day opening stock

thank you federico it works