topic Straight Table with Expression Not displaying all Data in QlikView https://community.qlik.com/t5/QlikView/Straight-Table-with-Expression-Not-displaying-all-Data/m-p/75216#M770444 <HTML><HEAD></HEAD><BODY><P>I created a straight table with an expression to 'filter' the data.&nbsp; When I remove one of the columns, one of the records disappears!?&nbsp;&nbsp; What is going on here!&nbsp; See attached for example</P><P></P><P>Please help!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT brettaustin 2020-11-25T16:16:04Z Straight Table with Expression Not displaying all Data https://community.qlik.com/t5/QlikView/Straight-Table-with-Expression-Not-displaying-all-Data/m-p/75216#M770444 <HTML><HEAD></HEAD><BODY><P>I created a straight table with an expression to 'filter' the data.&nbsp; When I remove one of the columns, one of the records disappears!?&nbsp;&nbsp; What is going on here!&nbsp; See attached for example</P><P></P><P>Please help!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Straight-Table-with-Expression-Not-displaying-all-Data/m-p/75216#M770444 brettaustin 2020-11-25T16:16:04Z Re: Straight Table with Expression Not displaying all Data https://community.qlik.com/t5/QlikView/Straight-Table-with-Expression-Not-displaying-all-Data/m-p/75217#M770445 <HTML><HEAD></HEAD><BODY><P>Try using set analysis instead of if statement</P><P></P><P><STRONG>Only({&lt;Status = {'5. Validation'}, [Current State] = {'Y'}&gt;} Status)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/204707_Capture.PNG" style="height: 138px; width: 620px;" /><BR /></STRONG></P></BODY></HTML> Fri, 08 Jun 2018 13:08:47 GMT https://community.qlik.com/t5/QlikView/Straight-Table-with-Expression-Not-displaying-all-Data/m-p/75217#M770445 sunny_talwar 2018-06-08T13:08:47Z Re: Straight Table with Expression Not displaying all Data https://community.qlik.com/t5/QlikView/Straight-Table-with-Expression-Not-displaying-all-Data/m-p/75218#M770447 <HTML><HEAD></HEAD><BODY><P>Works GREAT!&nbsp; Thank you Sunny!</P></BODY></HTML> Fri, 08 Jun 2018 13:33:27 GMT https://community.qlik.com/t5/QlikView/Straight-Table-with-Expression-Not-displaying-all-Data/m-p/75218#M770447 brettaustin 2018-06-08T13:33:27Z