topic Re: Set Analysis to exclude Dates in QlikView

Set Analysis to exclude Dates

Mon, 21 Sep 2015 21:17:43 GMT

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'))

Re: Set Analysis to exclude Dates

Oleg_Troyansky — Mon, 21 Sep 2015 22:33:39 GMT

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

Re: Set Analysis to exclude Dates

PrashantSangle — Tue, 22 Sep 2015 04:07:34 GMT

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

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

Regards

Re: Set Analysis to exclude Dates

sasiparupudi1 — Tue, 22 Sep 2015 06:11:24 GMT

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