1 Reply Latest reply: Sep 3, 2012 11:12 PM by matthew thompson RSS

    Aggregation of a range of fields

      Hello,

       

       

      According to the piece attached "plan_comptable_navision"

      For example, I have in a state of Microsoft Dynamics Navision, a line 10800999 (total capital accounts), I want to calculate the sum of all credit accounts between [10000000.10800999] (totaling column).

       

       

      You will also find the picture that I have already created Qlik View, which I could not display the sum of the credits in this interval.

      Piece attached "Pcomptable".

       

       

      I thought about putting in the expression of the amount claclul flow:

      an IF condition (Totaling <> ' ', ....) but I'm stuck because I don't know how to specify the bounds of the interval.

       

       

      Thank you for your help!