peek emty rows - Qlik Community

Report Inappropriate Content · ‎2017-02-15

Hi guys,

when i use the peek function only one field is filled by value. The following field is empty:

First step:

then i do a residnet load with the following code:

, if((MFLSAH>=0),MFLSAH,
if((BILANZKONTENNUMMER = peek(BILANZKONTENNUMMER)), peek(MFLSAH),0)
) as [LANDESWÄHRUNG - SALDO ALT HABEN]

and the rusult is:

How can i get this reuslt?

Thanks in advance,

Florian

vishsaggi · ‎2017-02-15

Try this?

LOAD ID, IF(Len(Trim(Value)) = 0, Peek(Values), Value) AS Values;

LOAD * INLINE [

ID, Value

21, 342776,69

22, 342776,69

23, 342776,69

24,

25,

26, 342776,69

];

maxgro · ‎2017-02-15

Try with an ordered (by ID) resident load

This is an example

X:

LOAD * INLINE [

ID, Value

26, 1

25, 2

23, 3

24,

22,

21, 5

];

Y:

NoConcatenate LOAD

ID,

IF(Len(Trim(Value)) = 0, Peek('Value'), Value) AS Value

Resident X

Order By ID

;

DROP Table X;

Result with order by Result Without order by

Report Inappropriate Content · ‎2017-02-15

I will try your approach tomorrow. What happend if the value is null ?

maxgro · ‎2017-02-15

Len(Trim(Value)) is 0 for Value = null