topic Re: problem in modeling in QlikView https://community.qlik.com/t5/QlikView/problem-in-modeling/m-p/76926#M771176 <HTML><HEAD></HEAD><BODY><P>hello</P><P>in your data,</P><P>Contract_ID 2 has a balance equal to 0</P><P>Contract_ID 3 has no balance</P><P>so what do you want to see ?</P><P>if you don't want balance=0 to be included, use a set analysis like Balance-={'0'}</P></BODY></HTML> Wed, 23 May 2018 07:20:52 GMT olivierrobin 2018-05-23T07:20:52Z problem in modeling https://community.qlik.com/t5/QlikView/problem-in-modeling/m-p/76925#M771175 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have a problem in my qlikview report:</P><P>I have some loan contracts which have some dedicated collateral and also every month&nbsp; a part of them will be paid and remain balance(should be paid in next months) are calculated and stored in another table.</P><P>The problem is : in collateral tab I want to show only collaterals which their remain balance is not zero </P><P></P><P>In attached file: when I filter 20180701 I expect to see just contract no 1 &amp;2 (not 3,because its balance in this date is zero)</P><P></P><P>Does anybody have a solution ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/problem-in-modeling/m-p/76925#M771175 Masi_Sahargahi 2020-11-25T16:16:04Z Re: problem in modeling https://community.qlik.com/t5/QlikView/problem-in-modeling/m-p/76926#M771176 <HTML><HEAD></HEAD><BODY><P>hello</P><P>in your data,</P><P>Contract_ID 2 has a balance equal to 0</P><P>Contract_ID 3 has no balance</P><P>so what do you want to see ?</P><P>if you don't want balance=0 to be included, use a set analysis like Balance-={'0'}</P></BODY></HTML> Wed, 23 May 2018 07:20:52 GMT https://community.qlik.com/t5/QlikView/problem-in-modeling/m-p/76926#M771176 olivierrobin 2018-05-23T07:20:52Z