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 :
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 ?