topic Re: Set Analysis / Calculating floating age in QlikView

Set Analysis / Calculating floating age

ArnaudTML — Sat, 16 Nov 2024 04:10:10 GMT

Hi,

How to calculate an age in relation to a selected date via set analysis ? (like a birthday or a employee's seniority)

Does the function "age" work ?

raman_rastogi — Thu, 14 Mar 2019 15:18:32 GMT

Try Interval Function .

Expression :- Interval(Date -Today(),'DD' )

ArnaudTML — Fri, 15 Mar 2019 07:33:49 GMT

It works but not with selected dates :

Count({$<Interval(MakeDate(Année,Mois,Jour)-ContratTravailDate,'YY')={"<1"}>}%ContratTravailID)

raman_rastogi — Fri, 15 Mar 2019 08:03:11 GMT

Hi,

Try below expressions

Ex- Count(if( Interval(MakeDate(Année,Mois,Jour)-ContratTravailDate,'YY') < '1' , %ContratTravailID))

Count({< %ContratTravailID= {"=Interval(MakeDate(Année,Mois,Jour)-ContratTravailDate,'YY')<1"} >} %ContratTravailID)

ArnaudTML — Mon, 18 Mar 2019 09:04:20 GMT

It doesn't work...

I have hiring dates in date + numeric "ContratTravailDateEntreeReference" + seniority date in numeric "$(vDateAnciennete1An)" in a table :

But if I make this in a dynamic cross table with set analysis, the result is 0 :

Count( {$< ContratTravailDateEntreeReference = {"> $(=vDateAnciennete1An)"} >} %SalarieID)