topic Re: If statement in Splunk Search

If statement

vaibhavbeohar — Fri, 29 Mar 2013 06:22:42 GMT

Hi
I am running search to get rating status in my report, not getting any result and getting error
" Error in 'eval' command: The expression is malformed. Expected ) " here is my search,

Thanks

"sourcetype="TicketAnalysis" | eval XYZ = if (Rating1 >="6", "Satisfied", if (Rating1 <="6" AND Rating1 >= "4" "Neutral", if (Rating1 < "4" AND Rating1 >= 1, "Dissatisfied","Unrated"))) "

Re: If statement

smolcj — Fri, 29 Mar 2013 06:32:51 GMT

sourcetype="TicketAnalysis" | eval XYZ = if (Rating1 >="6", "Satisfied", if (Rating1 <="6" AND Rating1 >= "4" **,** "Neutral", if (Rating1 < "4" AND Rating1 >= 1, "Dissatisfied","Unrated")))

i think you missed a comma in second if statement . if (Rating1 <="6" AND Rating1 >= "4" , "Neutral"

Re: If statement

vaibhavbeohar — Fri, 29 Mar 2013 07:03:52 GMT

Thanks, this works now ,but if i select pie graph i am getting extra field other (1), do you have any idea why its coming only on pie graph ?

Re: If statement

smolcj — Fri, 29 Mar 2013 07:17:18 GMT

🙂 you have an option to remove other from pie graph in a dashboard . append this
0
thisanswer may help you;;

Re: If statement

jhupka — Fri, 29 Mar 2013 21:05:45 GMT

Is there any particular reason you wouldn't use case instead?

Re: If statement

jbanerje — Tue, 29 Sep 2020 06:53:30 GMT

eval Comment=if((Fund_Credit_Amt=Ack_Credit_Amt) AND (Fund_Debit_Amt=Ack_Debit_Amt) ,"MATCH","MISMATCH")