Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Rajitha1
Contributor III
Contributor III

Sum of list percentage in current year

I have a dataset in that one column name is enquiries it having closed, opened, in progress  data is like that  

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

Labels (1)
1 Solution

Accepted Solutions
Bunim
Contributor III
Contributor III

count({<Year={$(=year(today()))},enquiries ={closed}>}enquiries )
/
count({<Year={$(=year(today()))},enquiries -={closed}>}enquiries )

View solution in original post

1 Reply
Bunim
Contributor III
Contributor III

count({<Year={$(=year(today()))},enquiries ={closed}>}enquiries )
/
count({<Year={$(=year(today()))},enquiries -={closed}>}enquiries )