https://community.qlik.com/t5/App-Development/Set-Analysis-in-combination-with-Filter-that-has-if-condition/m-p/2120492#M91257 <P>In a sheet I have a filter on Balance Date as seen below:</P> <P>=if([Balance Date]&lt;&gt;'$(Min_BlcDate)',[Balance Date])  </P> <P>Also I have column that uses Balance date in set analysis as follows:</P> <P>Sum({&lt;[Balance Date] = {'$(VPreviousBalanceDate)'}&gt;}Value)</P> <P>The issue is that due to condition on the filter, the column is returning zero but once i remove the condition, the output is correct. Could you please help me resolve this issue.&nbsp;</P> <P>Thanks in Advance!</P> <P><LI-WRAPPER></LI-WRAPPER></P> <P><LI-WRAPPER></LI-WRAPPER></P> Wed, 20 Sep 2023 14:04:51 GMT Deepashree 2023-09-20T14:04:51Z https://community.qlik.com/t5/App-Development/Set-Analysis-in-combination-with-Filter-that-has-if-condition/m-p/2120492#M91257 <P>In a sheet I have a filter on Balance Date as seen below:</P> <P>=if([Balance Date]&lt;&gt;'$(Min_BlcDate)',[Balance Date])  </P> <P>Also I have column that uses Balance date in set analysis as follows:</P> <P>Sum({&lt;[Balance Date] = {'$(VPreviousBalanceDate)'}&gt;}Value)</P> <P>The issue is that due to condition on the filter, the column is returning zero but once i remove the condition, the output is correct. Could you please help me resolve this issue.&nbsp;</P> <P>Thanks in Advance!</P> <P><LI-WRAPPER></LI-WRAPPER></P> <P><LI-WRAPPER></LI-WRAPPER></P> Wed, 20 Sep 2023 14:04:51 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-in-combination-with-Filter-that-has-if-condition/m-p/2120492#M91257 Deepashree 2023-09-20T14:04:51Z https://community.qlik.com/t5/App-Development/Set-Analysis-in-combination-with-Filter-that-has-if-condition/m-p/2121457#M91314 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/134070">@Deepashree</a>&nbsp;,</P> <P>I don't understand your issue. Can you add some screens to explain?</P> <P>Regards.</P> Fri, 22 Sep 2023 15:09:37 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-in-combination-with-Filter-that-has-if-condition/m-p/2121457#M91314 sbaro_bd 2023-09-22T15:09:37Z