topic Re: Date Difference in QlikView

Date Difference

upaliwije — Mon, 15 Sep 2014 07:06:31 GMT

I have following script to calculate the Days_left

num(makedate(2014,8,31))>0, num(POL_PERIOD_TO)- num(makedate(2014,8,31)),0) as DAYS_LEFT

The resulting table is as follows and Total of Days_Left sum to 636 where as Actual number of Days_left is 212

How can I restrict the No of Days_left appear as 212 (modification to Script)

geert_gelade — Mon, 15 Sep 2014 07:14:49 GMT

If I understand your question, you want to show 212 in the resulting table instead of 636.

In that case you can just change the Total Mode to "max" on the Expressions tab of you table.

jagan — Mon, 15 Sep 2014 07:21:47 GMT

Hi,

Try Interval() to get the date difference

=Interval(POL_PERIOD_TO - makedate(2014,8,31), 'D')

Num(POL_PERIOD_TO) - makedate(2014,8,31)

Hope this helps you.

Regards,

Jagan.