No idea what im doing wrong

[samuel_brierley]

Time	=Speed	=Max(Speed)
1	10	10
2	20	20
3	30	30
4	40	40
5	50	50
6	60	60

I have a spreadsheet with the first 2 collumns i.e time and speed. the third column is a calculation in qlikview and the table shows the results. can somebody explain why =max is NOT producing 60 in each field and how to rectify it?

thanks

[swuehl · Accepted solution]

Try

=max(TOTAL Speed)

[samuel_brierley]

thanks

[#4]

Hi Samuel

in script check out this,

just instead on inline load your excel data

Sample:

Load * Inline [

Time,Speed

1,10

2,20

3,30

4,40

5,50

6,60

];

Left Join(Sample)

Load

Max(Speed) as Max

Resident tst;

Regards,

Ravikant

[johnca]

Like Ravikant said, but instead of Resident tst it should be Resident Sample.

(Usually) always better to calculate what you can in the load script. If this were a large document all that calculation time and memory is at your users' expense.

V/R,

John

[#6]

HI John,

     In Hurry Forgot To Change the Name.

Sorry for that.