topic Re: How to Store Max Value in Load Script in QlikView

How to Store Max Value in Load Script

Anonymous — Mon, 22 Feb 2016 15:30:28 GMT

Hello,

It's possible to use some function in Load command in the script to store the Max Value until find a higher value than the existing to create a table in a QlikView object?

Example:

ID	Value	Max Value
1	10	10
2	8	10
3	9	10
4	11	11
5	7	11
6	9	11

Kind Regards.

Re: How to Store Max Value in Load Script

sunny_talwar — Mon, 22 Feb 2016 16:54:29 GMT

You can use a combination of Peek/Previous with RangeMax to do this.

Script:

Table:

LOAD ID,

Value,

RangeMax(Peek('Max Value'), Value) as [Max Value]

FROM

[https://community.qlik.com/thread/206511]

(html, codepage is 1252, embedded labels, table is @1);

Re: How to Store Max Value in Load Script

nagarjuna_kotha — Mon, 22 Feb 2016 16:57:19 GMT

Hi, Can you tell what exactly output you want for above data ?

-Nagarjun

Re: How to Store Max Value in Load Script

Anonymous — Mon, 22 Feb 2016 20:17:05 GMT

When i using the function with a table that uses Qualify *; the function is not displayed correctly, can you tell me why this behavior happen?

Re: How to Store Max Value in Load Script

sunny_talwar — Mon, 22 Feb 2016 20:49:33 GMT

I will have to look at the script to give you an answer.