How to get the max value in an array ?

[#1]

Hi all,

I'm newbie in Qlik and I'm trying to understand some basic concepts of Qlikview.

I have a table with record number and a random number assigned to it. So it is like;

1 5

2 2

3 7

4 9 ... so on.

I want to get max value of record number on the left column so that I can use it in another calculation on the script. I'm using something like ;

let maxtry = max([trial time]);

But this expression returns null on the script. All helps appreciated .

PS : I've tried to use this expression on a text box and I can show the maximum value of this array in this box. I still don't understand why is it working on text expression side and not working on script side.

[sunny_talwar · Accepted solution]

You need to add another load in between to find the max value

Table:

LOAD SNo,

          TrialTime

FROM Source

MaxTrialTime:

LOAD Max(TrialTime) as MaxTrialTime

Resident Table;

LET maxtry = Peek('MaxTrialTime');

DROP Table MaxTrialTime;