topic Filter rows of a table with Enable Conditional? in QlikView https://community.qlik.com/t5/QlikView/Filter-rows-of-a-table-with-Enable-Conditional/m-p/649248#M237536 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I want to create two separate straight tables for the same content, but in one table I want to show all the records that have the status = closed, while in the other table, I want to show all records that have a status = open.</P><P></P><P>I thought I could use the Enable Conditional on that used dimension and type in: DocStatus = 'Open'</P><P></P><P>All it does, it hides that dimension (column) but it still shows all records. How can I simply hide these records?</P><P></P><P>Obviously I can't use a list box, otherwise it will not work with the second table where I want to show the other records.</P><P></P><P>Any help highly appreciated.</P></BODY></HTML> Tue, 26 Aug 2014 08:32:53 GMT 2014-08-26T08:32:53Z Filter rows of a table with Enable Conditional? https://community.qlik.com/t5/QlikView/Filter-rows-of-a-table-with-Enable-Conditional/m-p/649248#M237536 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I want to create two separate straight tables for the same content, but in one table I want to show all the records that have the status = closed, while in the other table, I want to show all records that have a status = open.</P><P></P><P>I thought I could use the Enable Conditional on that used dimension and type in: DocStatus = 'Open'</P><P></P><P>All it does, it hides that dimension (column) but it still shows all records. How can I simply hide these records?</P><P></P><P>Obviously I can't use a list box, otherwise it will not work with the second table where I want to show the other records.</P><P></P><P>Any help highly appreciated.</P></BODY></HTML> Tue, 26 Aug 2014 08:32:53 GMT https://community.qlik.com/t5/QlikView/Filter-rows-of-a-table-with-Enable-Conditional/m-p/649248#M237536 2014-08-26T08:32:53Z Re: Filter rows of a table with Enable Conditional? https://community.qlik.com/t5/QlikView/Filter-rows-of-a-table-with-Enable-Conditional/m-p/649249#M237537 <HTML><HEAD></HEAD><BODY><P>I found the solution.</P><P></P><P>Instead of the Enable Conditional, I have to use a calculated dimension using a If(DocStatus='Closed',DocStatus) and then check the "Suppress When Value is Null"</P></BODY></HTML> Tue, 26 Aug 2014 08:39:57 GMT https://community.qlik.com/t5/QlikView/Filter-rows-of-a-table-with-Enable-Conditional/m-p/649249#M237537 2014-08-26T08:39:57Z