topic Re: Expression help in QlikView

Expression help

Wed, 25 Nov 2020 16:16:04 GMT

Dear Experts,

My expression like this,

IF(EFF_YEAR=2015,RANGESUM(PRE_2016+LIFE_PRE-GV-LS+POL_FEES+CESS1)*.11,RANGESUM(PRE_2016+LIFE_PRE-GV-LS+POL_FEES+CESS1)*.15)

I want to change this to have the results like ,

IF(EFF_DATE BEFORE 01/05/2016,RANGESUM(PRE_2016+LIFE_PRE-GV-LS+POL_FEES+CESS1)*.11,RANGESUM(PRE_2016+LIFE_PRE-GV-LS+POL_FEES+CESS1)*.15)

wHATS WRONG WITH THIS . CAN ANY ONE HELP?

pRIYANTHA.

Re: Expression help

Anonymous — Tue, 14 Jun 2016 11:10:43 GMT

Hi Pritantha,

RANGESUM(PRE_2016,LIFE_PRE-GV-LS,POL_FEES,CESS1)*IF(EFF_DATE <= '01/05/2016',0.11,0.15)

Regards!

Re: Expression help

MayilVahanan — Tue, 14 Jun 2016 11:14:37 GMT

Try like this

IF(EFF_DATE <= 01/05/2016,RANGESUM(PRE_2016+LIFE_PRE-GV-LS+POL_FEES+CESS1)*.11,RANGESUM(PRE_2016+LIFE_PRE-GV-LS+POL_FEES+CESS1)*.15)

Re: Expression help

muthukumar77 — Tue, 14 Jun 2016 11:24:38 GMT

Hi,

=IF(EFF_DATE < '01/05/2016',RANGESUM(PRE_2016+LIFE_PRE-GV-LS+POL_FEES+CESS1)*.11,RANGESUM(PRE_2016+LIFE_PRE-GV-LS+POL_FEES+CESS1)*.15)

Re: Expression help

sunny_talwar — Tue, 14 Jun 2016 11:26:47 GMT

I think we would all be guessing for the right answer without a sample to play around with (plus knowing the expected output). Would you be able to provide one?

Re: Expression help

Wed, 22 Jun 2016 03:23:38 GMT

Thkx........

Re: Expression help

Wed, 22 Jun 2016 03:23:57 GMT

Thkx......