topic Data extraction between 2 dates in QlikView

Data extraction between 2 dates

absekrafi — Wed, 25 Nov 2020 16:16:04 GMT

Dear Qlikview community,

I have to extract data from oracle database tables which have date as a field.

I want to extract data between a start date and an end date.

Do you know how to implement that in Qlikview?

Thank you in advance,

Re: Data extraction between 2 dates

YoussefBelloum — Wed, 12 Sep 2018 15:43:33 GMT

Hi,

do you mean you want to get the difference between two Date values ?

example:

Date1: 01/01/2018

Date2: 30/01/2018

difference = 29 days

Re: Data extraction between 2 dates

giovanneb — Wed, 12 Sep 2018 15:47:32 GMT

Hi, try this

Where

date >= '2018/01/01' AND date<= '2018/09/12';

Best Reguards

Re: Data extraction between 2 dates

dplr-rn — Wed, 12 Sep 2018 15:50:39 GMT

Depends on scenario if you want to select data between 2 dates create slider/calendar objects attached to from and to variables utilize these depending on scenario

1)with triggers to make the master calendar selections

2) or use in set analysis count({<Date={'>=$(vStartDate)<=$(vEndDate)'}>} distinct Customer)

below video is useful

Selecting Arbitrary Date Ranges - YouTube

if as youssef asked difference between 2 date values thats a different scenario

Re: Data extraction between 2 dates

vishsaggi — Wed, 12 Sep 2018 18:33:04 GMT

may be you want to try like in your SQL Script:

SQL

SELECT yourfieldlist, Field2, Field3, DateField....

FROM yoursourcetable a,

(Select Min(DateField) AS MinDate, Max(DateField) AS MaxDate

FROM yoursourcetable)b

WHERE a.DateField between MinDate and MaxDate;

Re: Data extraction between 2 dates

absekrafi — Fri, 14 Sep 2018 09:02:37 GMT

Hi Dilip,

Thank you very much I think the second option is the answer to what I want to do.

I will check that on Qlikview and let you know.

Best regards

Re: Data extraction between 2 dates

absekrafi — Fri, 14 Sep 2018 09:04:52 GMT

Hi Vishwarath,

Thank you for the solution, I will try it and let you know.

Kind regards

Re: Data extraction between 2 dates

absekrafi — Mon, 24 Sep 2018 13:14:14 GMT

Hi Dilip, Hi Vishwarath,

I created two fields startdate and enddate and two selections lists.

When I select the startdate the enddate is locked and in a cross table I put this expression:

count ({Date={'>=$(STARTDATE)<=$(ENDDATE)'}>} distinct QTEPROD but it didn't work.

STARTDATE and ENDDATE are to fields of a master calendar.

Thank you in advance,

Abdallah