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

    MAX and MIN function

    Julien CHOLLET

      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