topic Re: [QlikView] How to select a date between two dates in QlikView

[QlikView] How to select a date between two dates

Wed, 26 Apr 2017 12:56:03 GMT

Hello,

I would like to select from a list of selection a date. This selected date would then allow me to display the start date of the contract and the date of end of contract. So, we have a date interval in which our selected date must be included. I use "set analysis" but it does not work ".

=Sum({$

<[Année début de validité] = {">=$(=Année1)"}>*

<[Année fin de la période de validité] = {"<=$(=Année1)"}>*

<[Mois début de validité] = {">=$(=Mois1)"}>

*<Mois1 = {"<=$(=[Mois fin de la période de validité])"}>

} [Début de validité])

Re: [QlikView] How to select a date between two dates

Anonymous — Wed, 26 Apr 2017 16:01:12 GMT

could you post some sample data please , English prefered

Re: [QlikView] How to select a date between two dates

Thu, 27 Apr 2017 06:08:05 GMT

I want that from the date(Année, Mois) I select from the two bars at the top, qlikview displays me all entries where this date is between "debut de validite" and "fin de la période"

This code work to to find by year :

=Sum({$

<[Année début de validité] = {">=$(=Année1)"}> /

<[Année fin de la période de validité] = {"<=$(=Année1)"}>} [Début de validité])

But i want a selection by Years AND Months. There isn't any relation between the two bars at the top and the list at the bottom.

Thanks for your help

Re: [QlikView] How to select a date between two dates

prachisangewar — Thu, 27 Apr 2017 06:24:13 GMT

Hi,

Instead of the two blocks (one for Year and one for Month) you can create two calendar objects to Select the Start Date and End Date.

You can go through the below video for the steps.

Selecting Arbitrary Date Ranges

Re: [QlikView] How to select a date between two dates

Thu, 27 Apr 2017 06:29:58 GMT

My fields are declared like this :

Re: [QlikView] How to select a date between two dates

Thu, 27 Apr 2017 06:51:02 GMT

In SQL language, my request will be :

SELECT * from [début de validité], [Fin de la période de validité] where Année1>=[Année début de validité] AND Année1<=[Année fin de la période de validité] -> (Select * where Mois1>=[Année début de validité] AND Mois1<=[Mois fin de la période de validité])

Re: [QlikView] How to select a date between two dates

Anil_Babu_Samineni — Thu, 27 Apr 2017 06:54:19 GMT

Does Année1 & Mois1 are related each??

Re: [QlikView] How to select a date between two dates

Thu, 27 Apr 2017 07:00:08 GMT

They aren't related

Re: [QlikView] How to select a date between two dates

Thu, 27 Apr 2017 07:00:56 GMT

Ok thanks, let's see how to create calendar objects, thanks

Re: [QlikView] How to select a date between two dates

Thu, 27 Apr 2017 07:09:20 GMT

I think calendar object can't help me because i want the user have only to clik on a Year or a Month to display the result, it's faster for the user

Re: [QlikView] How to select a date between two dates

Thu, 27 Apr 2017 09:16:28 GMT

I try with the calendar, with one date but i only have dates who are =([Début de validité] & '<=' & Date), i want, from this script, get all the values who are !=null and where Date is <= [Fin période de validité].

Thanks

Re: [QlikView] How to select a date between two dates

Fri, 28 Apr 2017 07:18:35 GMT

Ok, i have a correct answer. I have used some MakeDate function to regroup my field Year and Month together and compare them to my date with this setAnalysis :

=Sum({$ <YMD = {"<=$(=YM)"}> * <YMF = {">=$(=YM)"}>} [Début de validité])

Lexique : YMD : Year,Month,Début; YMF: Year,Month,Fin and YM: Year,Month

Have a nice day,

Alex