Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to find "closed" percentage in current year in Qlik sense with bar chart
=count({<year={$(=max(year))},enquiry={'closed'}>}dealerid)/count({<year={$(=max(year))}>}dealerid)
for the below data, im getting the correct output.
count({<year={"$(=Year(Today()))"},enquiry={'closed'}>}dealerid) / count({<Year={"$(=year(Today()))"}>}dealerid)
I am not getting anything for that
=count({<year={$(=max(year))},enquiry={'closed'}>}dealerid)/count({<year={$(=max(year))}>}dealerid)
for the below data, im getting the correct output.
thats for the latest year. number of total closed dealers in latest year / total dealers in year 2022(including all sorts of enquiry values)
Thank you fallenangel6
Its working.....
Thanks,
Rajitha Bhumireddy