topic Re: Script: Inter-record comparison of values. in QlikView

Script: Inter-record comparison of values.

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone,

I am working with hierarchies. I now wanted to add one additional column to data that is linked to a hierarchy.

Unfortunately QlikView adds the additional values to too many values in the existing columns.

I've attached a table preview to make it more clear.

I only want to assign the value "Scope Q2" to the last instance of 204074-01 (with the hierarchy key G2).

Is it possible to check the next value in the field "Management ID" and only assign the value "Scope Q2"

to the row if the next Management ID is different?

Thank you in advance!

Best regards,

Mats

rwunderlich — Wed, 10 May 2017 22:02:31 GMT

You can use the peek() script function to look ahead or back in records when loading. See the Help for info about peek().

-Rob

swuehl — Wed, 10 May 2017 22:47:08 GMT

Hi Rob,

how would you use Peek() to address the next record to be read in? Is this a new feature? Haven't seen this so far.

Regards,

Stefan

rwunderlich — Wed, 10 May 2017 23:03:53 GMT

Not a new feature, but only works on resident tables as far as I know. RecNo() represents the peek row of the next record.

data:

LOAD * INLINE [

];

data2:

LOAD

peek('X', recno(), 'data') as Y

RESIDENT data;

-Rob

swuehl — Wed, 10 May 2017 23:11:31 GMT

Ah, you are talking about peek'ing a resident table, that's what I missed.

Thought you have found a way to peek the next record from an input table that's currently loaded.

Thanks for clarification.

Anonymous — Thu, 11 May 2017 19:32:52 GMT

It took me a while but I figured out how to use it in my application.

Thank you Rob!