Set Analysis to exclude Dates

[#1]

I have a date ranging from 03/20/1995 to 06/27/2015. I wan't to only include any data linked with years 2014 and 2015. How would I write the set analysis to exclude anything before 2014?

Initial thoughts

=if(DateSigned <= '01/01/2014', null(),num(avg(date(DateOfCreation) - date(DateSigned)), '#,##0'))

[Oleg_Troyansky]

I'd suggest something like this:

num(

     avg({<DateSigned={"=year(DateSigned)>=2014"}>} DateOfCreation - DateSigned)

, '#,##0')

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

[PrashantSangle]

Hi,

You can create new field for year of Date Signed in script using year()

like Year(DateSigned) as DateSignedYear

and use that field to compare in set analysis

like

num(avg({<DateSignedYear={"<2014"}>} DateOfCreate - DateSigned),'#,##0')

Regards

[sasiparupudi1]

num(avg({<DateSignedYear={">'01/01/2014'"}>} DateOfCreate - DateSigned),'#,##0')