Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try
=max(TOTAL Speed)
thanks
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
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
HI John,
In Hurry Forgot To Change the Name.
Sorry for that.