1 Reply Latest reply: Jul 14, 2015 11:37 AM by Ramon Covarrubias RSS

    MAX and MIN function



      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 ?


      Thank you