Finding Max Value within a Table

Fri, 17 Jul 2009 03:52:21 GMT

Hey, I have an expression in a table that calulate the slope of two points for a line graph. What I would like to do is just show the maxium slope or slopes in the table. This is the code I have:

=
(Count({<Dateentered={'$(EndCompareDate)'} >} Model) - Count({<Dateentered={'$(StartCompareDate)'}>} Model) )
 /
(num(Left(EndCompareDate,2)) - num(Left(StartCompareDate, 2)))

I tried using Max() and RangeMax() but neither of these worked. Any ideas?

Finding Max Value within a Table

johnw — Fri, 17 Jul 2009 04:15:17 GMT

I'd have to see both your table and how you want to view this to say for sure, but I think you want something along these lines:

=max(aggr(your expression,your table dimensions with commas between them))

topic Finding Max Value within a Table in QlikView

Finding Max Value within a Table

Finding Max Value within a Table