Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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