Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlik Community!
I have a pivot table that shows counts for checks that have been cleared vs. issued by check date. In the pivot table, I have the totals turned on so I can see the total number of checks for each date. What I'm trying to do is calculate the percentage of checks in each status by check date. So far, I have been able to determine the percent of checks still in the "Issued" status by using the expression below, but I would also like to see the percentage displayed for the "Cleared" status. Any thoughts on how I can accomplish this?
Count({<[PAYMENT_STATUS]-= {'Cleared'}>} [PAYMENT_NUMBER])/Count(TOTAL <CHECK_DATE> {<[PAYMENT_STATUS]-= {'Issued'}>} [PAYMENT_NUMBER])
Thank you!
No need for a response. I was able to determine that I can get what I'm looking for using the following:
Count([PAYMENT_NUMBER])/Count(TOTAL <CHECK_DATE> [PAYMENT_NUMBER])
No need for a response. I was able to determine that I can get what I'm looking for using the following:
Count([PAYMENT_NUMBER])/Count(TOTAL <CHECK_DATE> [PAYMENT_NUMBER])