topic Re: max expression in QlikView

max expression

runesson — Wed, 25 Nov 2020 16:16:04 GMT

Using a straight chart with the dimension of meter number.
The expression is =NUM(SUM({$< DATE = {"2018-01*}>}Data),'# ##0') which gives me the sum of consumption for the month of january, data is hourly values.
I would like to add three more expressions to show me the top three values for current month.
To get the max I use =max(Data), =max(Data,2), =max(Data,3) but cant figure out how to add month to the max expression.
The final result is to see a twelve months with top 3 three hourly consumptions and the total of the month.

Re: max expression

Vegar — Sat, 02 Mar 2019 19:11:34 GMT

Max() and sum() are both aggregation functions where SET could be used.
Try adding your set
{$< DATE = {"2018-01*}>}
into your max expressions.
Like:
= MAX( {$< DATE = {"2018-01*}>} Data,2)

Re: max expression

runesson — Mon, 04 Mar 2019 06:07:21 GMT

Worked, thanks!