Assistance please

[Anonymous]

HI QLIKERS

Actually i am running below code in Visualization expression to count OpportunityName for current year only but it counts for whole years which mean it does not consider giving parameters exist  

count({$<2017={'01/01/2017'}>} OpportunityName)

please help

[Clever_Anjos]

do you have a field called "2017"?

[Anonymous]

No it is not , i have made a culomn in script using makedate(year(today())) as currentyear and i replaced with 2017 but its still count whole years since 2013 until now !

[Clever_Anjos]

count({$<[youshouldhaveafieldnamehere]={'01/01/2017'}>}

Useful reading: A Primer on Set Analysis

[Anonymous]

Thank you for provided link but it is not working even when put currentyear field

[phaneendra_kunc]

count({$<CurrentYearField={'2017'}>} OpportunityName)

Try this..

Hoping CurrentYearField will have

2017

2016

2015...

[Anonymous]

Actually i have created "current year" using function as below

Makedate(year(today())) which must take only current year but still when i run aggr it returns the whole years counts but i want it to return count for current year

[phaneendra_kunc]

Can you take out MAKEDATE and just do below for CurrentYear Field?

Year(today()) as [current year]

[Anonymous]

Yes but  sadly still its not working

[eduardo_dimperio]

HI Ibrahibra,

When you create the field using Year(today()) as [current year] like phaneendra.kunche said, what's the result?

Cause when you said "not working" we don't know if it return nothing or a wrong value