Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Percentage

I'm not sure if there's a way to do this or not.

If you look at the table, what I'd like to display is the % corresponding to the CPT Code, not to the overall total.

IE, for 99213, the percentages I"m looking for are 1,444/(1,444+37,308) for the denied part and 37,308/(1,444+37,308) for the paid portion.

I realize clicking on this would bring me right to the results, but to avoid confusion I need show the percentages as above.

Any idea on how I could do this?

1 Solution

Accepted Solutions
vgutkovsky
Master II
Master II

You can try something like this:count(field)/count(total <[CPT Code]> field)

Regards,

View solution in original post

3 Replies
vgutkovsky
Master II
Master II

You can try something like this:count(field)/count(total <[CPT Code]> field)

Regards,

Not applicable
Author

You will want to use the TOTAL modifier to ignore the dimension, allowing you to get the total for Paid and Denied. You want to respect the selection on CPT Code, so you need to TOTAL by that field.

Something like this:

Sum(Amount)/Sum(TOTAL <CPTCode> Amount)


That should work for both Paid and Denied. Replace the CPTCode and Amount with the field names from your dataset.

Not applicable
Author

Thanks, exactly what I needed.