problem in modeling

[Masi_Sahargahi]

Hi all,

I have a problem in my qlikview report:

I have some loan contracts which have some dedicated collateral and also every month  a part of them will be paid and remain balance(should be paid in next months) are calculated and stored in another table.

The problem is : in collateral tab I want to show only collaterals which their remain balance is not zero

In attached file: when I filter 20180701 I expect to see just contract no 1 &2 (not 3,because its balance in this date is zero)

Does anybody have a solution ?

[olivierrobin · Accepted solution]

hello

in your data,

Contract_ID 2 has a balance equal to 0

Contract_ID 3 has no balance

so what do you want to see ?

if you don't want balance=0 to be included, use a set analysis like Balance-={'0'}