Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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