topic Re: Need help with script in QlikView

Need help with script

Mon, 19 Jan 2015 10:20:49 GMT

i have 7 fields

Date

plant no

material no.

closing stock,

opening stock,

open stock,

last stock,

Now in closing stock and last stock there are many null values what i want to do is if plant no and material no. is same of previous date and closing stock is null then copy above date closing stock in current closing stock.

I am attaching excel sheet and 1 qvw ... please help

Re: Need help with script

francoiscave — Mon, 19 Jan 2015 11:04:06 GMT

Hi Navneet,

See like below and attached files:

It's good ?

Have fun with QV,

François

Re: Need help with script

Anonymous — Mon, 19 Jan 2015 11:38:30 GMT

Hi,

Try:

load *,

if([Plant Code]= Previous([Plant Code]) and [Material Number]= Previous([Material Number]) and len(Trim([Closing Stock])) = 0,Previous([Closing Stock]),[Closing Stock]) as ClosingStock;
LOAD [Plant Code],
[Material Number],
Date,
[Closing Stock],
[Last Stock],
DPM,
[Open stock],
[Opening stock]
FROM

(biff, embedded labels, table is Sheet1$);

Regards

Neetha

Re: Need help with script

francoiscave — Thu, 22 Jan 2015 13:04:25 GMT

Hi Navneet,

Have you find a solution ?

If your are satisfied by a response, please mark it as correct or helpful to close this tread.

If not, how can we help you?

Thanks,

François