topic Re: Peek function in QlikView

Peek function

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

How to use peek in stright table expression with if condition

Re: Peek function

swuehl — Mon, 30 May 2016 09:42:38 GMT

Peek() is a inter record function for use in the script only.

You can look into chart inter record functions like Above() / Below():

=Above(Sum(Value))

Re: Peek function

Anonymous — Mon, 30 May 2016 09:50:31 GMT

Hi,

Like swuehl already mentioned, you can use Peek() only in the script.

Refer to this help page for inter-record functions, where you can read which functions work only oin charts, script ofr both.

Inter-record functions ‒ QlikView

Re: Peek function

sunny_talwar — Mon, 30 May 2016 11:03:50 GMT

What is your exact requirement? May be if you provide a sample to look at with your expected output, we may be able to offer you better help.

Just to add to the responses of above two, there is also Before/After which are used for pivoted dimensions in a pivot table. But once again it would be better if you can share a sample

Re: Peek function

Mon, 30 May 2016 11:13:28 GMT

Hi sunny,

I need to implement below one.

Rate XP

1. 1- Rate

3. 1-(prev XP)*(1-Rate),

; and so on

Re: Peek function

sunny_talwar — Mon, 30 May 2016 11:35:10 GMT

This is still an incomplete sample. Would it be possibe to provide few rows of data (may be in an excel file) with the expected output?

Re: Peek function

swuehl — Mon, 30 May 2016 11:39:28 GMT

Maybe something like this:

Use Rate field as dimension (or better a primary key of your input table?), then create an expression labelled "XP"

=If(rowno() =1, 1- Rate, 1- Above("XP")*(1-Rate) )

Re: Peek function

Mon, 30 May 2016 12:07:02 GMT

Hi sunny,

I have fields like below

Id rate

1 3

2 4

3 5

4 2

And so on

I need to calculate XP field using below logic

For first record XP is Rate value

For 2nd record XP is 1-(1- previous XP)*(1- current record Rate value)

And so on

Id Rate XP

1 3 3

Plz help me