How to Store Max Value in Load Script

[Anonymous]

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.

[sunny_talwar]

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);

[nagarjuna_kotha]

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

-Nagarjun

[Anonymous]

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?

[sunny_talwar]

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