# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Partner

## Re: Calculation for the next day opening stock

Or maybe a fake data with the same fields.

New Contributor

## Re: Calculation for the next day opening stock

i have attached the file above

Partner

## Re: Calculation for the next day opening stock

Try with this one

I hope it helps

Highlighted
New Contributor

## Re: Calculation for the next day opening stock

Federico,

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

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

## Re: Calculation for the next day opening stock

Hi,

Use this:

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

Cheers

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

## 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,
New Contributor

## Re: Calculation for the next day opening stock

thank you federico it works