Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set Analysis % Calculation

Below is my calculation to get the amount of money by pay type for a range.

Sum({<[Amt Paid] ={">0<2500"}>}[Amt Paid])

What I would like to do is now calculate the percent on that range so check would be about 54/56%, I thought it was as simple as " / sum([Amt Paid])" however that just takes the over all total? not just the summed section.  Do i need to write another analysis set to capture and divide the total?

Thank you in advance for any assistance anyone can provide

Capture.PNG

1 Reply
sunny_talwar