Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Assistance please

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

9 Replies
Clever_Anjos
Employee
Employee

do you have a field called "2017"?

Anonymous
Not applicable
Author

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
Employee
Employee

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


Useful reading: A Primer on Set Analysis

Anonymous
Not applicable
Author

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

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

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


Try this..


Hoping CurrentYearField will have

2017

2016

2015...

Anonymous
Not applicable
Author

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
Partner - Specialist III
Partner - Specialist III

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

Year(today()) as [current year]

Anonymous
Not applicable
Author

Yes but  sadly still its not working

eduardo_dimperio
Specialist II
Specialist II

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