topic Year(field) in Set Analysis doesn't work in QlikView

Year(field) in Set Analysis doesn't work

Thu, 17 Jul 2014 08:46:42 GMT

Before asking , I have found a similar topic but it doesn't work when trying to adapt mine.

I want to filter the result by counting only the records of this year

if I display the =YEAR(SCContract__c.StartDate__c) then I get 2013 , 2014 ...

here my expression

I want to consider all the values , so I did use the {1

but how to evaluate the Year of the StartDate ?

=COUNT({1<{$(=YEAR(SCContract__c.StartDate__c))}={'2014'}>}SCCContract__c.StartDate__c)

Thanks for your explainations

Alban

SergeyMak — Thu, 17 Jul 2014 08:53:34 GMT

As I know you can't use formula in the left part in set analysis.

Just do YEAR(SCContract__c.StartDate__c) AS YearStartDate in load script

and then use

COUNT({1<YearStartDate={2014}>}SCCContract__c.StartDate__c) as your expression

its_anandrjs — Thu, 17 Jul 2014 08:58:10 GMT

Try with

Max(YearFieldValue) in the expression