Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression help

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.

1 Solution

Accepted Solutions
MayilVahanan

Hi

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)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

6 Replies
Anonymous
Not applicable
Author

Hi Pritantha,

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


Regards!

MayilVahanan

Hi

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)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
muthukumar77
Partner - Creator III
Partner - Creator III

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)

Muthukumar Pandiyan
sunny_talwar

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?

Not applicable
Author

Thkx........

Not applicable
Author

Thkx......