Find current year percentage

[Rajitha1]

how to find "closed" percentage in current year in Qlik sense with bar chart

[Tzvibe]

count({<year={"$(=Year(Today()))"},enquiry={'closed'}>}dealerid) / count({<Year={"$(=year(Today()))"}>}dealerid)

[Rajitha1]

I am not getting anything for that

[fallenangel6 · Accepted solution]

=count({<year={$(=max(year))},enquiry={'closed'}>}dealerid)/count({<year={$(=max(year))}>}dealerid)

for the below data, im getting the correct output.

[fallenangel6]

thats for the latest year.  number of total closed dealers in latest year / total dealers in year 2022(including all sorts of enquiry values)

[Rajitha1 · Accepted solution]

Thank you fallenangel6 

Its working.....

Thanks,

Rajitha Bhumireddy