topic Re: four years in QlikView

four years

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

Hi all I want to calculate the age of less than 4years and greater than 4yeras like attached how to calculate

olivierrobin — Tue, 20 Mar 2018 10:33:43 GMT

hello,

something like this

if(Today()-MyDate>365*4-1,'gt than 4 years',

'less than 4 years')

YoussefBelloum — Tue, 20 Mar 2018 10:41:45 GMT

Hi,

tell us more about your data structure? what is your date field type ?

do you calculate the age from a range of dates or you are comparing with today date ?

soniasweety — Tue, 20 Mar 2018 10:47:42 GMT

My date field is

started_on = 10/26/2016 2:07:02 AM

yes its based on today date

tresB — Tue, 20 Mar 2018 10:53:36 GMT

Age() is there in qlik. Try like:

If(Age(today(), yourdate)>=4, '>= four', '< four')

sasiparupudi1 — Tue, 20 Mar 2018 10:54:06 GMT

=Date(Addyears(Date#('10/26/2016 2:07:02 AM','MM/DD/YYYY h:mm:ss TT'),4))>Today()

YoussefBelloum — Tue, 20 Mar 2018 10:54:27 GMT

=if(Date(started_on)-AddYears(Timestamp(today()),-1)<1460,'less tha...','greater than..')

soniasweety — Thu, 22 Mar 2018 07:28:12 GMT

done change in expression this is also working

if(((Date(Today(),'DD-MM-YYYY')

-Date(Floor(Num([My_date])),'DD-MM-YYYY'))/365)>4,'Greater than 4 years','Lesser than 4 years') as by_Age,

tresB — Thu, 22 Mar 2018 08:29:26 GMT

I see few unnecessary (majorly formatting) functions, you can get rid of. The equivalent would be:

if((Today()-[My_date])/365>4,'Greater than 4 years','Lesser than 4 years') as by_Age,