topic Re: Interval of dates in QlikView

Interval of dates

ecolomer — Fri, 18 Jul 2014 06:22:12 GMT

Hi,

I have a file with ths data:

- Task

- Initial Date

- Final Date

And I need to select an interval of dates and visualize all the tasks with one o more date into the interval selected.

TX in advance

SunilChauhan — Fri, 18 Jul 2014 06:27:01 GMT

interval(

[Initial Date]-

[Final Date],'HH')

or age(

[Initial Date]

, [Final Date])

hope this helps

jagan — Fri, 18 Jul 2014 06:48:15 GMT

Hi,

Can you come up with some sample data and expected output. It helps to easily providing the solution.

Regards,

Jagan.

Fri, 18 Jul 2014 07:03:27 GMT

try this

interval(date(Final Date)-date(Initial Date))

ecolomer — Fri, 18 Jul 2014 07:20:32 GMT

hic — Fri, 18 Jul 2014 07:26:59 GMT

You should take a look at the following two articles:

HIC

Fri, 18 Jul 2014 07:29:34 GMT

This gives the differences in hours.

Interval(DATE(date#('10-10-2014','DD-MM-YYYY'))-date(date#('10-09-2014','DD-MM-YYYY')))

and this gives the differences in days

DATE(date#('10-10-2014','DD-MM-YYYY'))-date(date#('10-09-2014','DD-MM-YYYY'))

hope this helps you.

ecolomer — Fri, 18 Jul 2014 09:27:29 GMT

Very Good.

Thank's