topic Peek field for some values having null and not null in QlikView

Peek field for some values having null and not null

saumyashah90 — Thu, 06 Jun 2013 12:34:21 GMT

I have Data as shown below

Header 1	Header 2	Header 3
a	1	HI
a	1
a	2
a	2
a	3	HELLO
b	3
b	3

else

PFA 1.JPG

I want to repeat Header3 value i.e" HI " for value of Header2 "1" ,and not for "2",same for HELLO for Header2 value "3"

I used Peek

Command : If(IsNull(Header3),Peek(Header3),Header3)

but it shows HI value for Header2 value "1" and "2" both

as Shown

Header 1	Header 2	Header 3
a	1	HI
a	1	HI
a	2	HI
a	2	HI
a	3	HELLO
b	3	HELLO
b	3	HELLO

Re: Peek field for some values having null and not null

swuehl — Thu, 06 Jun 2013 12:37:55 GMT

Try

If(IsNull(Header3) and Header2 = peek(Header2),Peek(Header3),Header3)

Re: Peek field for some values having null and not null

saumyashah90 — Wed, 12 Jun 2013 07:58:58 GMT

Nope, not getting

Re: Peek field for some values having null and not null

Gysbert_Wassenaar — Wed, 12 Jun 2013 12:02:39 GMT

Try:

LOAD

[Header 1]

, [Header 2]

, if(len(trim([Header 3]))=0 and Previous([Header 2])=[Header 2], peek([Header 3]),[Header 3]) as [Header 3]

// , RowNo() as rowid

INLINE [

Header 1, Header 2, Header 3

a, 1, HI

a, 1,

a, 2,

a, 3, HELLO

b, 3,

b, 3

];

See attached example

Re: Peek field for some values having null and not null

saumyashah90 — Fri, 12 Jul 2013 07:14:24 GMT

Hi Gysbert

I got proper output using RowNo() as RowId.

Can you tell me reason for existence of RowNo() as RowId?

Because when i reload it withour using RowNo i dont get proper required output.

Re: Peek field for some values having null and not null

er_mohit — Fri, 12 Jul 2013 07:37:50 GMT

See the attached file excel and qlikview

hope it helps you

Re: Peek field for some values having null and not null

saumyashah90 — Fri, 12 Jul 2013 07:48:07 GMT

Hey i am sorry if i am was not specific.

I meant to say for that particular solution(which gysbert gave) i need to know it

According to me without Rowno() also we should get proper ouput but its not

Re: Peek field for some values having null and not null

saumyashah90 — Fri, 12 Jul 2013 07:58:49 GMT

Hey mohit,

I understood

Thanks