topic Mapping two dates in set analysis in QlikView

Mapping two dates in set analysis

Anonymous — Tue, 11 Apr 2017 15:06:16 GMT

Hi All,

I have a requirement to map dates in UI scripting ,How to add Rating year in below set analysis

when 201703 and onwards month_year selected rating year should be 2016 else it should be 2015:

Count({<[Month_Year] = {'$(vMaxMonthYear)'}>} [Employee Count])

Month_Year	Rating Year
201603	2015
201604	2015
201605	2015
201606	2015
201607	2015
201608	2015
201609	2015
201610	2015
201611	2015
201612	2015
201701	2015
201702	2015
201703	2016
201704	2016

Any help is appreciated.

Thanks & Regards

Neetha

Re: Mapping two dates in set analysis

sunny_talwar — Tue, 11 Apr 2017 15:14:05 GMT

May be this

Count({<[Month_Year] = {'$(vMaxMonthYear)'}, [Rating Year] = {$(=If(Max(Month_Year) >= 201703, '2016', '2015'))}>} [Employee Count])

Re: Mapping two dates in set analysis

Anonymous — Tue, 11 Apr 2017 15:33:45 GMT

Hi Sunny,

Thanks for quick response, quiet modified your syntax:

=If(Max(Month_Year) >='$(vMaxMonthYear)' , Max(RYear), Max(RYear)-1) - This works

=Count({<[Worker Status]= {'$(vWorkerstatus_Inactive)'}, [Termination Count] = {1}, [Month_Year] = {'$(vMaxMonthYear)'},[Rating Year] = {$(=If(Max(Month_Year) >= {'$(vMaxMonthYear)'}, Max([Rating Year] ), Max([Rating Year] )-1))}>} [Employee Count]) - but this doesn't work.

Thanks

Neetha

Re: Mapping two dates in set analysis

sunny_talwar — Tue, 11 Apr 2017 15:38:45 GMT

Why the curly brackets? May be this

=Count({<[Worker Status]= {'$(vWorkerstatus_Inactive)'}, [Termination Count] = {1}, [Month_Year] = {'$(vMaxMonthYear)'},[Rating Year] = {$(=If(Max(Month_Year) >='$(vMaxMonthYear)' , Max(RYear), Max(RYear)-1))}>} [Employee Count])