How to get the max value in an array ?

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: How to get the max value in an array ?

sunny_talwar — Thu, 05 May 2016 14:56:15 GMT

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;

topic How to get the max value in an array ? in QlikView

How to get the max value in an array ?

Re: How to get the max value in an array ?