topic GET A ZERO VALUE in Reporting Service & Alerting https://community.qlik.com/t5/Reporting-Service-Alerting/GET-A-ZERO-VALUE/m-p/1932120#M213 <P>DEAR ALL</P> <P>All I want to do is use the EXPRESSION below to get values that have only a value zero.</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; expression -&nbsp; &nbsp; &nbsp;SUM(ACTUAL)</P> <TABLE width="293"> <TBODY> <TR> <TD width="207">NOTE_DESC</TD> <TD width="86">MC</TD> </TR> <TR> <TD>STAFF SALARIES</TD> <TD>2</TD> </TR> <TR> <TD>CONTRACT WAGES</TD> <TD>25</TD> </TR> <TR> <TD>EPF</TD> <TD>2</TD> </TR> <TR> <TD>ETF</TD> <TD>25</TD> </TR> <TR> <TD>PENSION FUND CONTRIBUTION</TD> <TD>-</TD> </TR> <TR> <TD>GRATUITY</TD> <TD>2</TD> </TR> <TR> <TD>MEDICAL FUND</TD> <TD>25</TD> </TR> <TR> <TD>INSURANCE - STAFF</TD> <TD>2</TD> </TR> <TR> <TD>ANNUAL BONUS</TD> <TD>25</TD> </TR> <TR> <TD>SPORTS CLUB</TD> <TD>2</TD> </TR> <TR> <TD>STAFF WELFARE</TD> <TD>25</TD> </TR> <TR> <TD>INTEREST REBATE ON HOUSING LOANS</TD> <TD>-</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> Fri, 15 Nov 2024 22:11:12 GMT sagaraperera 2024-11-15T22:11:12Z GET A ZERO VALUE https://community.qlik.com/t5/Reporting-Service-Alerting/GET-A-ZERO-VALUE/m-p/1932120#M213 <P>DEAR ALL</P> <P>All I want to do is use the EXPRESSION below to get values that have only a value zero.</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; expression -&nbsp; &nbsp; &nbsp;SUM(ACTUAL)</P> <TABLE width="293"> <TBODY> <TR> <TD width="207">NOTE_DESC</TD> <TD width="86">MC</TD> </TR> <TR> <TD>STAFF SALARIES</TD> <TD>2</TD> </TR> <TR> <TD>CONTRACT WAGES</TD> <TD>25</TD> </TR> <TR> <TD>EPF</TD> <TD>2</TD> </TR> <TR> <TD>ETF</TD> <TD>25</TD> </TR> <TR> <TD>PENSION FUND CONTRIBUTION</TD> <TD>-</TD> </TR> <TR> <TD>GRATUITY</TD> <TD>2</TD> </TR> <TR> <TD>MEDICAL FUND</TD> <TD>25</TD> </TR> <TR> <TD>INSURANCE - STAFF</TD> <TD>2</TD> </TR> <TR> <TD>ANNUAL BONUS</TD> <TD>25</TD> </TR> <TR> <TD>SPORTS CLUB</TD> <TD>2</TD> </TR> <TR> <TD>STAFF WELFARE</TD> <TD>25</TD> </TR> <TR> <TD>INTEREST REBATE ON HOUSING LOANS</TD> <TD>-</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> Fri, 15 Nov 2024 22:11:12 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/GET-A-ZERO-VALUE/m-p/1932120#M213 sagaraperera 2024-11-15T22:11:12Z Re: GET A ZERO VALUE https://community.qlik.com/t5/Reporting-Service-Alerting/GET-A-ZERO-VALUE/m-p/1932961#M216 <P>Hi,</P> <P>As I understood you want to show sum of Actual where MC is null or empty or -. if so you can use the following expression:</P> <P>SUM({$-&lt;MC-={'*', '-', ''}&gt;}ACTUAL)</P> <P>Regards,</P> <P>Vitalii</P> Thu, 19 May 2022 10:40:03 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/GET-A-ZERO-VALUE/m-p/1932961#M216 vchuprina 2022-05-19T10:40:03Z