Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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 )