Next table value if null

maestro444 — Mon, 26 Nov 2012 10:43:56 GMT

TIME FILENAME VALUE1 VALUE2

2012.11.26 00:01:17	AAEU.csv	0	1.29662
2012.11.26 00:01:17	INEU.csv	1.2967	0
2012.11.26 00:01:18	AAEU.csv	0	1.29666
2012.11.26 00:01:19	AAEU.csv	0	1.29669
2012.11.26 00:01:20	AAEU.csv	0	1.29669
2012.11.26 00:01:49	AAEU.csv	0	1.29669
2012.11.26 00:02:02	AAEU.csv	0	1.29671
2012.11.26 00:02:02	INEU.csv	1.29671	0
2012.11.26 00:02:07	AAEU.csv	0	1.296855
2012.11.26 00:02:08	AAEU.csv	0	1.29681

Hello, is there any function that can help solving following issue?

I have a range of values which i want to compare by time,

I need the following logic: If row value equals to zero, then take previous value which is not equal to zero.

I've tried previous function, but I made mistake in the formula, as I am not familiar with creating counters. And looks like some kind of counters should be created there to pick the right value avove.

=IF(VALUE1=0,previous(VALUE1),VALUE1 as VALUE1_COUNTED,

Would be very thankful for any hints.

Re: Next table value if null

Gysbert_Wassenaar — Mon, 26 Nov 2012 11:02:53 GMT

It's not clear to me what you want. Try this and see if it does what you need:

LOAD Time,

filename,

if(rowno()=1 or INEU<>0,INEU,peek('NewINEU')) as NewINEU,

AAEU

FROM Data.skv

(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

Re: Next table value if null

maestro444 — Mon, 26 Nov 2012 11:27:47 GMT

Thanks! That's exactly what I wanted.

topic Re: Next table value if null in QlikView

Next table value if null

Re: Next table value if null

Re: Next table value if null