5 Replies Latest reply: Jan 28, 2015 5:23 PM by Henrique Falcao RSS

    Hide Dates used to calculate running total

    Henrique Falcao

      Hello!

       

      I´m evaluating Qlik Sense, so I´m new to this...

       

      There is any way, with expressions, to use some field for calculation even if I don´t select it in a filter?

       

      I´m using this to get the running balance of a bank account:

      Total Balance: RANGESUM(ABOVE(SUM({$<ACCOUNT = P(ACCOUNT)>} BALANCE),0,ROWNO()))

      This is what I´ve got (the total balance is OK so far):

       

      bal1.png


      But if I deselect the date 02/12/2002, the total balance got wrong:

       

      bal2.png

       

      If I use {1} in the formula it will bring me all dates, and I dont want that: RANGESUM(ABOVE(SUM({1<ACCOUNT = P(ACCOUNT)>} BALANCE),0,ROWNO()))

       

      BAL3.png

       

      What I´m trying to do is to use all dates to calculate the TOTAL BALANCE, but just show the row of the selected dates on the table/graph.