Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
See why Qlik was named a Leader in the 2025 Gartner® Magic Quadrant™ for Augmented Data Quality Solutions: GET THE REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
FinancePerson
Contributor
Contributor

Excluding a line from a calculated expression in qlikview

Good morning everyone,

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. 

=if([Calculated Net Ind]>0,[Gross Med Pd],if([Gross Med Pd]-([Recoveries]-[Gross Ind Pd])<0,0,[Gross Med Pd]-( Recoveries]-[Gross Ind Pd]))

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. 

Labels (2)
0 Replies