Discussion board where members can get started with Qlik Sense.
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
do you have a field called "2017"?
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 !
Useful reading: A Primer on Set Analysis
Thank you for provided link but it is not working even when put currentyear field
Hoping CurrentYearField will have
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
Can you take out MAKEDATE and just do below for CurrentYear Field?
Year(today()) as [current year]
Yes but sadly still its not working
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