topic Re: No idea what im doing wrong in QlikView

No idea what im doing wrong

samuel_brierley — Fri, 06 Dec 2013 13:23:27 GMT

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

Re: No idea what im doing wrong

swuehl — Fri, 06 Dec 2013 13:24:58 GMT

Try

=max(TOTAL Speed)

Re: No idea what im doing wrong

samuel_brierley — Fri, 06 Dec 2013 13:27:28 GMT

thanks

Re: No idea what im doing wrong

Fri, 06 Dec 2013 13:29:56 GMT

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

Re: No idea what im doing wrong

johnca — Fri, 06 Dec 2013 13:43:13 GMT

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

Re: No idea what im doing wrong

Fri, 06 Dec 2013 13:51:49 GMT

HI John,

In Hurry Forgot To Change the Name.

Sorry for that.