topic Re: Substracting two Dates in QlikView

Substracting two Dates

Wed, 11 Dec 2013 05:09:48 GMT

Hi,

I want to substract two dates. And the output should be Number of Days.

I want to display it in a bar graph against dimension.

I used this as my expression

=interval(DateSent-DateReceived,'DD')

But i am getting No data to display.

It shows only when i select any field.

Help me with this.

Thanks and Regards

Keerthi

jonathandienst — Wed, 11 Dec 2013 05:13:57 GMT

To get the date difference in days, just subtract the first date from the second.

=DateSent-DateReceived

You could round this with Round(), Floor() or Ceil() according to your requirements.

HTH

Jonathan

Wed, 11 Dec 2013 05:35:18 GMT

I am getting substracted date only when i select date received.

it should be displayed against a dimension in a chart.

How to do that ??

jagan — Wed, 11 Dec 2013 05:45:26 GMT

Hi,

If there are multiple records for the dimension then you don't get data, try using

=Ceil(Max(DateSent)-Max(DateReceived))

Hope it helps you.

Regards,

Jagan.

jonathandienst — Wed, 11 Dec 2013 05:49:33 GMT

What is the chart dimension? If the dates are not distinct per dimension line, you will to apply an aggregation function like Min() or Max().

Wed, 11 Dec 2013 05:51:05 GMT

chart dimension is insurer.

I have 7 insurer.

Wed, 11 Dec 2013 06:16:50 GMT

hi try this

=interval(num(DateSent)-num(DateReceived),'DD')