Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have created a date variable in QV app
vP16={'>={15-AUG-2016} <={01-SEP-2016'}
How ever this return 0 vale when applied in following expression
sum({<POL_TYPE={'N'},RISK_YEAR = {$(=Max(RISK_YEAR)-1)},RISK_DATE=$(vP16)>}Nos)
Pls advise where I have made the mistake
vP16='>=15-AUG-2016 <=01-SEP-2016'
sum({<POL_TYPE={'N'},RISK_YEAR = {$(=Max(RISK_YEAR)-1)},RISK_DATE={$(vP16)}>}Nos)
there will be error but it will work
why don't you directly write in set analysis instead of creating variable
sum({<POL_TYPE={'N'},RISK_YEAR = {$(=Max(RISK_YEAR)-1)},RISK_DATE={'>=15-AUG-2016 <=01-SEP-2016'}>}Nos)
or
vP16='>=15-AUG-2016 <=01-SEP-2016'
sum({<POL_TYPE={'N'},RISK_YEAR = {$(=Max(RISK_YEAR)-1)},RISK_DATE={'$(vP16)'}>}Nos)
Thanks Kushal
In fact I have several expression in doc so it is easy for me to use a variable. However your expression works but not when the expression with variable is applied. I feel something wrong with the definition of variable. Pls advise.
vP16='>=15-AUG-2016 <=01-SEP-2016'
sum({<POL_TYPE={'N'},RISK_YEAR = {$(=Max(RISK_YEAR)-1)},RISK_DATE={$(vP16)}>}Nos)
there will be error but it will work
Thanks a lot
Hi,
PFA, hope it will help.
Thanks
Raja.