Interval of dates

[ecolomer]

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]

interval(

[Initial Date]-

[Final Date],'HH')

or age(

[Initial Date]

, [Final Date])

hope this helps

[jagan]

Hi,

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

Regards,

Jagan.

[#4]

hi

try this

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

[ecolomer]

Proyecto	Tarea	Fecha Inicio	Fecha Fin
C42005C	Acoplar Componentes	14/07/2014 8:30	14/07/2014 17:30
C42005C	Capacitación	07/07/2014 8:30	11/07/2014 17:30
C42005C	Capacitación	17/07/2014 8:30	18/07/2014 17:30
CQ42416	Equipos / Armado	19/05/2014 8:30	19/05/2014 17:30
CQ42416	Equipos / Armado	20/05/2014 8:30	20/05/2014 17:30
CQ42416	Equipos / Armado	22/05/2014 8:30	22/05/2014 17:30
CQ42416	Equipos / Armado	23/05/2014 8:30	23/05/2014 17:30

[hic · Accepted solution]

You should take a look at the following two articles:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates

http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/04/intervalmatch

HIC

[#7]

HI

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]

Very Good.

Thank's