https://community.qlik.com/t5/QlikView/If-condition/m-p/1884179#M1216995 <P>Could it be something wrong with the second condition? I would have check if this expression returns any values.</P> <P>If( Expired_lastmonth='Expired', 'Exp', 'No') as total_exp_rev,</P> Sun, 23 Jan 2022 08:14:21 GMT Vegar 2022-01-23T08:14:21Z https://community.qlik.com/t5/QlikView/If-condition/m-p/1884147#M1216992 <P>Hi, i have two fields named as Blank and Expired_lastmonth. I am writing this piece of code, but it is throwing an error, can someone help me out?</P> <P>If(Blank='Expired' or Expired_lastmonth='Expired', 'Exp', 'No') as total_exp_rev.&nbsp;</P> <P>(As a result of the above code, the total_exp_rev has the values where blank is expired, but not for the Expired_lastmonth field)</P> Sat, 22 Jan 2022 15:38:29 GMT https://community.qlik.com/t5/QlikView/If-condition/m-p/1884147#M1216992 TanyaS 2022-01-22T15:38:29Z https://community.qlik.com/t5/QlikView/If-condition/m-p/1884155#M1216994 <P>Can you share the sample data how it looks..&nbsp;</P> Sat, 22 Jan 2022 16:33:02 GMT https://community.qlik.com/t5/QlikView/If-condition/m-p/1884155#M1216994 anat 2022-01-22T16:33:02Z https://community.qlik.com/t5/QlikView/If-condition/m-p/1884179#M1216995 <P>Could it be something wrong with the second condition? I would have check if this expression returns any values.</P> <P>If( Expired_lastmonth='Expired', 'Exp', 'No') as total_exp_rev,</P> Sun, 23 Jan 2022 08:14:21 GMT https://community.qlik.com/t5/QlikView/If-condition/m-p/1884179#M1216995 Vegar 2022-01-23T08:14:21Z