2 Replies Latest reply: Sep 12, 2017 3:53 PM by Carlos Luciano Ferreira RSS

    Previous Balance Calculation

    Carlos Luciano Ferreira

      Previous Balance Calculation

       

      Good afternoon everyone,

       

      I'm starting with Qlik Sense and in this community and would like to know if anyone could help me with the following question.

       

      I am using a maintenance order worksheet as Qlik data source. I would like to present the result in Qlik in the same way that it is calculated in this worksheet.

       

      In the data upload a field called "Period" was created in the format "Month / 9999" (Aug / 2017).

       

      When selecting the month of August for example I would like to calculate the previous balance of the orders, which is the sum (considering some criteria) of the orders of previous months. It turns out that by selecting this period it is no longer possible to calculate view information from previous months to obtain the previous balance.

       

      How could i solve this question?

       

      Thank you,