[QlikView] How to select a date between two dates

[#1]

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é])

[#2]

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

[#3 · Accepted solution]

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