topic Add days in QlikView

Add days

Wed, 21 May 2014 03:55:42 GMT

Hi All,

I am currently creating a Pivot table where in we have a the "START Time" in D/M/YYYY h:mm format and we have a field with "Due day" value.

I am trying to create a Measure "DUE DATE", which would be adding the number of days from "Due day" to "START Time".

I am attaching the sample data along with the expected output.

Thanks in Advance

Wed, 21 May 2014 04:41:11 GMT

When I use

Date(START TIME (DD/MM/YYYY h:mm)+4) it gives me the answer

However when I use

Date(START TIME (DD/MM/YYYY h:mm)+Due (in days)) it throws a '-' in the text box.

Wed, 21 May 2014 04:45:25 GMT

PFA.

Anonymous — Wed, 21 May 2014 04:52:36 GMT

In text box it will give error, but will provide correct result when a single date is selected.

You can just sum up in script as well and generate a new field as

Load

Date(START TIME (DD/MM/YYYY h:mm)+Due (in days)) as Due_Date

from table_name;

Now you can use this field easily..

Regards

Nitin

SergeyMak — Wed, 21 May 2014 05:23:02 GMT

You can use Interval function.

But firstly it's better to round START Time and Due day to date with Floor function in the load script.

I thin than you can also calculate this difference with Floor(Due day)-Floor(START Time).