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

    Aggregation of a range of fields




      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!