https://community.qlik.com/t5/QlikView/Filter-condition-Need-help-here/m-p/1540462#M439402 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/5345iC67C660A89FC563E/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span>Hi All,</P><P>Above is my dataset. now when i apply filter on Col6(list Box) let say value "33"&nbsp;the table&nbsp;shows 2&nbsp;records . Cuz the col6 has 2 records in table. But instead i need 3 rows . i.e 2 rows matching value 33 and also the last&nbsp;&nbsp;records if&nbsp;col4 is not null.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 21:27:38 GMT QlikNoviceDeveloper 2024-11-16T21:27:38Z https://community.qlik.com/t5/QlikView/Filter-condition-Need-help-here/m-p/1540462#M439402 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/5345iC67C660A89FC563E/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span>Hi All,</P><P>Above is my dataset. now when i apply filter on Col6(list Box) let say value "33"&nbsp;the table&nbsp;shows 2&nbsp;records . Cuz the col6 has 2 records in table. But instead i need 3 rows . i.e 2 rows matching value 33 and also the last&nbsp;&nbsp;records if&nbsp;col4 is not null.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 21:27:38 GMT https://community.qlik.com/t5/QlikView/Filter-condition-Need-help-here/m-p/1540462#M439402 QlikNoviceDeveloper 2024-11-16T21:27:38Z https://community.qlik.com/t5/QlikView/Filter-condition-Need-help-here/m-p/1540588#M439406 <P>Maybe something like</P><P>&nbsp;</P><P>Sum(Col1) + Sum({&lt;Col6={"=getselectedcount(Col6)&gt;1"} ,Col4={"=max(Col4)"},Col6=&gt;} Col1)</P> Thu, 07 Feb 2019 05:28:50 GMT https://community.qlik.com/t5/QlikView/Filter-condition-Need-help-here/m-p/1540588#M439406 qliksus 2019-02-07T05:28:50Z