topic Re: Peek() fuction in QlikView

Peek() fuction

Wed, 12 Mar 2014 05:28:15 GMT

Hi all,

Income,expensive,expensive 01,Income 01

1000,100,100,0

800,200,200,600

1500,300,200,500

but he want to see Income - expensive - expensive 01 + Income 01 as Income_total by using Peek() function only.

Please anyone help me

Re: Peek() fuction

jagan — Wed, 12 Mar 2014 05:35:13 GMT

Hi,

Try like this

Data:

LOAD

Previous([Income]) - Previous([expensive]) - Previous([expensive 01]) + Previous([Income 01]) as Income_total

INLINE [

Income,expensive,expensive 01,Income 01

1000,100,100,0

800,200,200,600

1500,300,200,500];

You can use Previous() for this. If you are not looking for this let me know your expected output.

Regards,

Jagan.

Re: Peek() fuction

jagan — Wed, 12 Mar 2014 05:36:06 GMT

Hi,

Check this hope it helps you.

Peek() vs Previous() – When to Use Each

Regards,

jagan.

Re: Peek() fuction

tresB — Wed, 12 Mar 2014 05:36:25 GMT

What is the output you are expecting from the above input?

Re: Peek() fuction

sushil353 — Wed, 12 Mar 2014 05:57:30 GMT

Hi ,

If you only want the total and strictly want peek function.. then try this:

set errormode =0;

Table:

LOAD * Inline

[

Income,expensive,expensive01,Income01

1000,100,100,0

800,200,200,600

1500,300,200,500

];

for i=0 to NoOfRows('Table')-1

test:

load Distinct

peek('Income',$(i),'Table')-peek('expensive',$(i),'Table')-peek('expensive01',$(i),'Table')+peek('Income01',$(i),'Table') as Total

Resident Table;

ENDIF

Re: Peek() fuction

sunilkumarqv — Wed, 12 Mar 2014 06:05:34 GMT

Try this

Re: Peek() fuction

sunilkumarqv — Wed, 12 Mar 2014 06:06:55 GMT

u can use Previous or peek function instead of complex scenarios

Re: Peek() fuction

sunilkumarqv Mar 12, 2014 2:05 AM (in response to muralivijay)

Try this

test1.qvwtest1.qvw148.8 K