Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
apalmtree
Contributor

Span between two date fields

Hi,

I have a table for items that have FROM dates and TO dates,

per item these FROM and TO can be overlaped and come in chains. there are several FROM and TO dates per item. 

In this case i want to establish he lenght between FOM and TOM, and se which ones that have a span longer than 30 days. So no gaps in the series of dates. and if one FROM date is equal to a previous TO date this is a chain and also needs to be counted for when it comes to number of days.

i rather this to be in the script but anything will do!

Thanks!

2 Replies
MVP
MVP

Re: Span between two date fields

Hi

I suggest that you post a sample qvw file and some sample data containing suitable dates to allow more specific and accurate help

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
apalmtree
Contributor

Re: Span between two date fields

Here's the qve file with sample data

Community Browser