Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 !
Thank you for provided link but it is not working even when put currentyear field
count({$<CurrentYearField={'2017'}>} OpportunityName)
Try this..
Hoping CurrentYearField will have
2017
2016
2015...
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
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