Aggregation of a range of fields

[#1]

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!

[#2]

Hi,

This should work: sum({<[Numero] = {">=10000000<=10800999"}>} [MontantCredit])

The example above uses set analysis to define the upper and lower limits of the account numbers you want to total.

I've also attached a qvw with this info below.

Hope this helps.

Matt