https://community.qlik.com/t5/QlikView/Excluding-a-line-from-a-calculated-expression-in-qlikview/m-p/1913270#M1218267 <P>Good morning everyone,</P> <P>Any help would be appreciated. I have a code that is a calculated expression but one claim needs to be excluded as an exception and calculated differently.&nbsp;</P> <P>=if([Calculated Net Ind]&gt;0,[Gross Med Pd],if([Gross Med Pd]-([Recoveries]-[Gross Ind Pd])&lt;0,0,[Gross Med Pd]-( Recoveries]-[Gross Ind Pd]))</P> <P>For the one specific line I need the calculated NET IND to be taken from the claim first, then calculated taken from EXP rather than MED but only for the one claim. I tried an if statement but, it wasn't working. Any help would be appreciated.&nbsp;</P> Fri, 01 Apr 2022 15:59:40 GMT FinancePerson 2022-04-01T15:59:40Z https://community.qlik.com/t5/QlikView/Excluding-a-line-from-a-calculated-expression-in-qlikview/m-p/1913270#M1218267 <P>Good morning everyone,</P> <P>Any help would be appreciated. I have a code that is a calculated expression but one claim needs to be excluded as an exception and calculated differently.&nbsp;</P> <P>=if([Calculated Net Ind]&gt;0,[Gross Med Pd],if([Gross Med Pd]-([Recoveries]-[Gross Ind Pd])&lt;0,0,[Gross Med Pd]-( Recoveries]-[Gross Ind Pd]))</P> <P>For the one specific line I need the calculated NET IND to be taken from the claim first, then calculated taken from EXP rather than MED but only for the one claim. I tried an if statement but, it wasn't working. Any help would be appreciated.&nbsp;</P> Fri, 01 Apr 2022 15:59:40 GMT https://community.qlik.com/t5/QlikView/Excluding-a-line-from-a-calculated-expression-in-qlikview/m-p/1913270#M1218267 FinancePerson 2022-04-01T15:59:40Z