Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview Pivot

   

I made a pivot to show two surgeons' supplies utilization. I want to show the number of cases in each row as a percent of the total cases. The formula I used will work if one surgeon is selected but If I select more than one it returns blank/zero. Does anyone know how to write a formula that will populate the "% of Total Vol" column? The Spreadsheet is below.

Thanks

   

SurgeonSurgeon 1Surgeon 2
MPC DescriptionCasesMPC Units Per CaseCost Per MPC%of Total VolCasesMPC Units Per CaseCost Per MPC% of Total Vol
TISSUE STRATTICEFO11100-----
TISSUE STRATTICE ADE2134,765-21235-
TISSUE STRAARS TTICE11786-----
ALLODERMISM  RTMTHICK21987-116,753-
GRAFTER ALLODERM215,674-114,563-
ALLODERM RTYTM41234-319,865-
GRAFT ALLOD423ERM22765-----
MESH WOUND VRMATRIX----128,797-
STEM FEM STANDARD128,765-----
Total15 8
Labels (1)
3 Replies
ramoncova06
Partner - Specialist III
Partner - Specialist III

count(total cases) will give you all the total cases, though if you select a filter the total will only apply to the possible values of the filter

count(total <Surgeon>Cases) , this is similar to the one above with the difference of grouping the total by Surgeon

Not applicable
Author

Thank you. I will do some work with the formula and let you know

Not applicable
Author

This maybe of help:

Count or Count distinct?

Link : Count or Count distinct?

Im not on my work computer but hopefully its in the right direction for you.