topic Re: Battling with an IF statement in a Sum Fields Function in QlikView

Battling with an IF statement in a Sum Fields Function

Mon, 10 Jun 2013 09:55:08 GMT

Hi guys,

i cant seem to get this one right, please can someone assist me with this?

sum({$<ClaimStatus={'Approved','Picked','Dispensed'}>}

(if(MedicalAidSchemeOptionID = 1811 or 1812 or 1813 or 1814 and tempSEP<114, (tempSEP*0.12),

if(MedicalAidSchemeOptionID = 1811 or 1812 or 1813 or 1814 and tempSEP>=114, 13.68,

if(MedicalAidSchemeOptionID = 1679 or 1676 or 803 or 463 or 1600 or 1761 or 1009 or 1694 or 1263 or 1010 or 308 or 307and tempSEP<114, (tempSEP*0.20),

if(MedicalAidSchemeOptionID = 1679 or 1676 or 803 or 463 or 1600 or 1761 or 1009 or 1694 or 1263 or 1010 or 308 or 307 and tempSEP>=114, 22.80,

[Service Fee 1]))))))

Re: Battling with an IF statement in a Sum Fields Function

Gysbert_Wassenaar — Mon, 10 Jun 2013 11:47:03 GMT

Try:

sum({$<ClaimStatus={'Approved','Picked','Dispensed'}>}

if( tempSEP < 114,

if(match(MedicalAidSchemeOptionID,1811,1812,1813,1815), tempSEP*0.12,

if(match(MedicalAidSchemeOptionID,1679,1676,803,463,1600,1761,1009,1694,1263,1010,308,307),tempSEP*0.20)

if(match(MedicalAidSchemeOptionID,1811,1812,1813,1815), 13.68,

if(match(MedicalAidSchemeOptionID,1679,1676,803,463,1600,1761,1009,1694,1263,1010,308,307),22.80)

)