https://community.qlik.com/t5/QlikView/How-to-Suppress-Zero-values-in-Straight-table-based-on-Button/m-p/2009437#M1221679 <P>Hi Experts,</P> <P>I am facing one issue in straight table to suppress the zero values based on the external button selection (Not Check the Suppress Zeros in Presentation tab).</P> <P>I have table like the below</P> <P>&nbsp;</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SuppressZero,&nbsp; All Values</P> <P>&nbsp;Account_ID,&nbsp; ActualDate, TransforDate, Charges, CD, Discount, NetRevenue(Charges+CD-Discount),&nbsp; NetPayments, Balance (NetRevenue-NetPayments)</P> <P>101,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10/11/2022,&nbsp; &nbsp;23/11/2022,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;500,&nbsp; &nbsp; 50,&nbsp; &nbsp; 30,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;520,&nbsp; &nbsp; &nbsp; &nbsp;460,&nbsp; &nbsp; &nbsp; 60</P> <P>102,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11/11/2022,&nbsp; &nbsp;24/11/2022,&nbsp; &nbsp; &nbsp; &nbsp; 450,&nbsp; &nbsp; &nbsp;100, 50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;500,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;500,&nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P> <P>103,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12/11/2022,&nbsp; &nbsp; 25/11/2022&nbsp; &nbsp; &nbsp; &nbsp; 350,&nbsp; &nbsp; &nbsp;0,&nbsp; &nbsp; &nbsp; 100,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;250,&nbsp; &nbsp; &nbsp; &nbsp; 250,&nbsp; &nbsp; &nbsp; &nbsp; 0</P> <P>104,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 13/11/2022,&nbsp; &nbsp; &nbsp;26/11/2022,&nbsp; &nbsp; &nbsp;650,&nbsp; &nbsp; &nbsp; 150,&nbsp; &nbsp; 0,&nbsp; &nbsp; &nbsp; &nbsp; 800,&nbsp; &nbsp; &nbsp; &nbsp; 900,&nbsp; &nbsp; &nbsp; -100</P> <P>&nbsp;</P> <P>I have My data like the above, when i click on Suppress zero button here i don't want see the records (102,103)with zero values in the Balance column records, If i click on All values button then i could see all the values in the table.</P> <P>Don not click on the Suppress Zero values in Presentation tab.</P> <P>Could you please help here how to approach.</P> <P>Thanks in advance&nbsp;</P> Sun, 27 Nov 2022 17:56:13 GMT narayanaqlik 2022-11-27T17:56:13Z https://community.qlik.com/t5/QlikView/How-to-Suppress-Zero-values-in-Straight-table-based-on-Button/m-p/2009437#M1221679 <P>Hi Experts,</P> <P>I am facing one issue in straight table to suppress the zero values based on the external button selection (Not Check the Suppress Zeros in Presentation tab).</P> <P>I have table like the below</P> <P>&nbsp;</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SuppressZero,&nbsp; All Values</P> <P>&nbsp;Account_ID,&nbsp; ActualDate, TransforDate, Charges, CD, Discount, NetRevenue(Charges+CD-Discount),&nbsp; NetPayments, Balance (NetRevenue-NetPayments)</P> <P>101,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10/11/2022,&nbsp; &nbsp;23/11/2022,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;500,&nbsp; &nbsp; 50,&nbsp; &nbsp; 30,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;520,&nbsp; &nbsp; &nbsp; &nbsp;460,&nbsp; &nbsp; &nbsp; 60</P> <P>102,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11/11/2022,&nbsp; &nbsp;24/11/2022,&nbsp; &nbsp; &nbsp; &nbsp; 450,&nbsp; &nbsp; &nbsp;100, 50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;500,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;500,&nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P> <P>103,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12/11/2022,&nbsp; &nbsp; 25/11/2022&nbsp; &nbsp; &nbsp; &nbsp; 350,&nbsp; &nbsp; &nbsp;0,&nbsp; &nbsp; &nbsp; 100,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;250,&nbsp; &nbsp; &nbsp; &nbsp; 250,&nbsp; &nbsp; &nbsp; &nbsp; 0</P> <P>104,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 13/11/2022,&nbsp; &nbsp; &nbsp;26/11/2022,&nbsp; &nbsp; &nbsp;650,&nbsp; &nbsp; &nbsp; 150,&nbsp; &nbsp; 0,&nbsp; &nbsp; &nbsp; &nbsp; 800,&nbsp; &nbsp; &nbsp; &nbsp; 900,&nbsp; &nbsp; &nbsp; -100</P> <P>&nbsp;</P> <P>I have My data like the above, when i click on Suppress zero button here i don't want see the records (102,103)with zero values in the Balance column records, If i click on All values button then i could see all the values in the table.</P> <P>Don not click on the Suppress Zero values in Presentation tab.</P> <P>Could you please help here how to approach.</P> <P>Thanks in advance&nbsp;</P> Sun, 27 Nov 2022 17:56:13 GMT https://community.qlik.com/t5/QlikView/How-to-Suppress-Zero-values-in-Straight-table-based-on-Button/m-p/2009437#M1221679 narayanaqlik 2022-11-27T17:56:13Z https://community.qlik.com/t5/QlikView/How-to-Suppress-Zero-values-in-Straight-table-based-on-Button/m-p/2009833#M1221713 <P>As far as I know, you can't actually do this directly. Your best bet would be to create two separate tables, one with Suppress Zero enabled and one where it is disabled, and then use a button / variable to toggle which one is shown.</P> Mon, 28 Nov 2022 14:58:26 GMT https://community.qlik.com/t5/QlikView/How-to-Suppress-Zero-values-in-Straight-table-based-on-Button/m-p/2009833#M1221713 Or 2022-11-28T14:58:26Z