topic Re: min/max within a date in load script in QlikView

min/max within a date in load script

Thu, 16 May 2013 17:22:56 GMT

Hello,

I have data like this:

date value

1/1/11 5

1/1/11 6

1/1/11 9

1/1/11 2

2/1/11 4

2/1/11 5

2/4/12 12

2/4/12 1

2/5/12 1

2/5/12 2

i need to make a table that for every date has the max value.

i want to do this in my load script.

thanks so much!!!

Re: min/max within a date in load script

Thu, 16 May 2013 17:29:51 GMT

load

date,

max(value) as maxvalue

from table

group by date;

Re: min/max within a date in load script

Anonymous — Thu, 16 May 2013 17:31:03 GMT

I guess that you want to find the max value, which is 12, and get the date where the value is 12.

tmp:
Load max(value) as MaxValue From yourtable;
LET vMaxValue=peek(MaxValue);
Drop table tmp;

Load date From yourtable
Where value = $(vMaxValue);

Regards,
Michael

Re: min/max within a date in load script

Thu, 16 May 2013 17:36:17 GMT

try this

AB:

LOAD * INLINE [

date, value

1/1/11, 5

1/1/11, 6

1/1/11, 9

1/1/11, 2

2/1/11, 4

2/1/11, 5

2/4/12, 12

2/4/12, 1

2/5/12, 1

];

LOAD date,max(value) as maxvalue

Resident AB

Group by date;

*********************************************************************

if you want the max value in value field for all date then try this.

load max(value) as max Resident AB;