Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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.

Span between two date fields


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!


2 Replies

Re: Span between two date fields


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


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

Re: Span between two date fields

Here's the qve file with sample data

Community Browser