MAX and MIN function

[#1]

Hi,

I would like to known how to use MAX and MIN function in qlik sense.

I have an excel file which include cashflows by day. I have 3 columns :

Date

Month

Treso

In Qlik Sense I have created a measure to calculate Cumulated Treso. It works well :

=rangesum( above( sum(Treso),0,rowno()))

But now I would like to create a table with max cashflow and min cashflow for each month. Is it possible in qlik sense ?

Cf. eg with my excel file.

I tried this function but I doesn't work :

=MAX(rangesum( above( sum(Treso),0,rowno())))

Could you please help me ?

Thank you

Sincerely

[ramoncova06]

you need to use an aggr

max(aggr(sum(Treso),Date))

min(aggr(sum(Treso),Date))