Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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