topic Re: want 0 count if keyword does not match in Splunk Search https://community.splunk.com/t5/Splunk-Search/want-0-count-if-keyword-does-not-match/m-p/105373#M183215 <P>Many Many thanks sdaniels for this , this really helped me a lot, I appreciate your help for this and hope to get same assistance in future also. Once again very very thanks <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Mon, 29 Oct 2012 18:25:58 GMT abhayneilam 2012-10-29T18:25:58Z want 0 count if keyword does not match https://community.splunk.com/t5/Splunk-Search/want-0-count-if-keyword-does-not-match/m-p/105371#M183213 <P>index="usb_weekly_data" |rex field="src_file_name" (?<KEY_WORD>(?i)"presentation") | stats count as First by key_word</KEY_WORD></P> <P>above query returns me :</P> <P>presentation 47</P> <P>but if I change the keyword to "halla" then it is not matching in the "src_field_name" field, then it should give me 0 as an output like :</P> <P>halla 0 </P> <P>Please help me to get this type of 0 output for non-matching keywords !!</P> <P>Please help me this time, I have been searching for the solution , but didnt get yet !!</P> <P>Your help would be highly appreciated !!</P> <P>Thanks in Advance </P> Mon, 28 Sep 2020 12:42:26 GMT https://community.splunk.com/t5/Splunk-Search/want-0-count-if-keyword-does-not-match/m-p/105371#M183213 abhayneilam 2020-09-28T12:42:26Z Re: want 0 count if keyword does not match https://community.splunk.com/t5/Splunk-Search/want-0-count-if-keyword-does-not-match/m-p/105372#M183214 <P>This previous answer may help so that you can represent no results found as a 0:</P> <P><A href="http://splunk-base.splunk.com/answers/59589/no-results-found-to-be-represented-as-null-or-0">http://splunk-base.splunk.com/answers/59589/no-results-found-to-be-represented-as-null-or-0</A></P> Mon, 29 Oct 2012 12:53:51 GMT https://community.splunk.com/t5/Splunk-Search/want-0-count-if-keyword-does-not-match/m-p/105372#M183214 sdaniels 2012-10-29T12:53:51Z Re: want 0 count if keyword does not match https://community.splunk.com/t5/Splunk-Search/want-0-count-if-keyword-does-not-match/m-p/105373#M183215 <P>Many Many thanks sdaniels for this , this really helped me a lot, I appreciate your help for this and hope to get same assistance in future also. Once again very very thanks <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Mon, 29 Oct 2012 18:25:58 GMT https://community.splunk.com/t5/Splunk-Search/want-0-count-if-keyword-does-not-match/m-p/105373#M183215 abhayneilam 2012-10-29T18:25:58Z