Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
See why Qlik was named a Leader in the 2025 Gartner® Magic Quadrant™ for Augmented Data Quality Solutions: GET THE REPORT
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 )