Set analyses on a calculated field instead of normal field

[qlikmark1990]

I currently am working on a financial application where I display a straight table with the balance of each month.

When I select the value Liquide middelen in field BalansOmschrijving2 I get the correct table. The column Saldototaal is the expression SUM (Bedrag * isDebetBoeking) - SUM (Bedrag * isCreditBoeking).

A part of the correct table is:

My selection is:

How do I make the correct set analysis expression for this selection on the calculated field Saldototaal so the table keeps the same when I clear all selections?

The expression that I tried but resulted in a table with the number 0 is:

SUM ({$<BalansOmschrijving2 = {"Liquide.Middelen"}>} (Bedrag * isDebetBoeking) - (Bedrag * isCreditBoeking))

[jensmunnichs]

Are the fields 'isDebetBoeking' and 'isCreditBoeking' flags with a value of 0 or 1 indicating whether they should be taken into consideration in your calculation? Because in that case you could do this:

Sum({1<BalansOmschrijving2 = {'Liquide.Middelen'}, isDebetBoeking = {1}>} Bedrag) -
Sum({1<BalansOmschrijving2 = {'Liquide.Middelen'}, isCreditBoeking = {1}>} Bedrag)

Note: If this doesn't work, one tip is that using '1' in front of your set analysis will make the calculation ignore selections.

[sunny_talwar · Accepted solution]

May be this

Sum({$<BalansOmschrijving2 = {"Liquide.Middelen"}>} Bedrag * isDebetBoeking) - Sum({$<BalansOmschrijving2 = {"Liquide.Middelen"}>} Bedrag * isCreditBoeking)

Do you have . between the Liquide and Middelen? Doesn't seem like within the  current selection box... so may be you need this

Sum({$<BalansOmschrijving2 = {"Liquide Middelen"}>} Bedrag * isDebetBoeking) - Sum({$<BalansOmschrijving2 = {"Liquide Middelen"}>} Bedrag * isCreditBoeking)