Peek function for more than one dimension

Thu, 09 Feb 2017 14:42:26 GMT

Hi,

I am trying to create values for every number in my table using the peek function. It's working with only one dimension but not with two. This is my input:

LOAD * INLINE [

No, Item, Value

1, A, 100

1, B, 50

4, A, 200

4, B, 300

5, A, 99

5, B, 400

];

and I want the output to look like this:

No	Item	A	B
1		100	50
2		100	50
3		100	50
4		200	300
5		99	400
6		99	400

I have tried with the following script:

NumberTable:

Load RecNo() as No

AutoGenerate (6);

Left join

LOAD * INLINE [

No, Item, Value

1, A, 100

1, B, 50

4, A, 200

4, B, 300

5, A, 99

5, B, 400

];

//NewTable:

NoConcatenate

Load No,

if(IsNull(Item),Peek(Item),Item) as Item,

if(IsNull(Value),Peek(Value),Value) as Value

Resident NumberTable

Order by No, Item Asc;

Drop Table NumberTable;

But the peek function is only working for Item B:

No	Item	A	B
1		100	50
2		-	50
3		-	50
4		200	300
5		99	400
6		-	400

Re: Peek function for more than one dimension

sunny_talwar — Thu, 09 Feb 2017 14:48:35 GMT

Try this:

NumberTable:

Load RecNo() as No

AutoGenerate (6);

Left Join (NumberTable)

LOAD * Inline [

Item

];

Left join

LOAD * INLINE [

No, Item, Value

1, A, 100

1, B, 50

4, A, 200

4, B, 300

5, A, 99

5, B, 400

];

NewTable:

NoConcatenate

Load No,

Item,

if(IsNull(Value),Peek(Value),Value) as Value

Resident NumberTable

Order by Item, No;

DROP Table NumberTable;

topic Peek function for more than one dimension in QlikView

Peek function for more than one dimension

Re: Peek function for more than one dimension