topic Re: Expression not working in QlikView

Expression not working

krishna20 — Wed, 10 Sep 2014 10:19:53 GMT

Hi Friends,

my condition is

if(Pol Expiry Date> SysDate Then

E.Premium = G.Premium

(Pol Expiry Date - Pol start Date)

* (Pol Expiry Date - SysDate)

Else

E.Premium = G.Premium

I converted this expression as

=if((TP_POL_TO_Date)>Today(),(sum(G.Premium) /

((TP_POL_TO_Date)-(TP_POL_FM_Date)))* ((TP_POL_TO_Date)-Today()),sum(G.Premium))

my dates are in format DD-MM-YYYY

Here , if condition is not working , its directly taking else condition.

What may the issue can anyone pls help out.

Thanks & Regards

kalyankrishna

PrashantSangle — Wed, 10 Sep 2014 10:23:58 GMT

Hi,

Try like this way

=if(Date(TP_POL_TO_Date)>Date(Today(),'DD-MM-YYYY'),(sum(G.Premium) /

((TP_POL_TO_Date)-(TP_POL_FM_Date)))* (Date(TP_POL_TO_Date)-Date(Today(),'DD_MM_YYYY'),sum(G.Premium))

Try like

=if(num(TP_POL_TO_Date)>floor(Today()),(sum(G.Premium) /

((TP_POL_TO_Date)-(TP_POL_FM_Date)))* ((TP_POL_TO_Date)-Today()),sum(G.Premium))

Regards

tresB — Wed, 10 Sep 2014 10:25:58 GMT

Perhaps your date field is being treated as text, use date#() to convert it to proper date and try like:

=if(Date#(TP_POL_TO_Date,'DD-MM-YYYY')>Today(),(.....

krishna20 — Wed, 10 Sep 2014 10:43:22 GMT

Hi ,

No change in this.

Regards

krishna

tresB — Wed, 10 Sep 2014 10:45:33 GMT

Possibly, your date field format is causing the issue. Try to share a qvw with sample data.