Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am new to Qlik Sense and I am trying to calculate an allocation percentage. I am using Qlik Sense and I am utilizing a table. I have the following column and rows
Provider | Facility | Patients Seen by Clinic | Patients Seen by % |
---|---|---|---|
Totals | 200 | ||
Jenny | Clinic 1 | 50 | |
Mary | Clinic 3 | 100 | |
Suzie | Clinic 4 | 50 |
I would like to calculate the Patients Seen by Clinic/Provider or 50/200. I am confused with the Aggr functions and the overall structure of the syntax
Sum(Provider)/ Sum(Patients Seen by Clinic should give me a % across the distribution of patients seen in the clinics...but I am getting nothing. Can someone help me.
Thanks,
Desmond
I tried everyone's suggestions to no avail. I am wondering if it has something to do with being text. I am reviewing functions now, to see if I need to somehow convert it. This is basically an uploaded Excel file put into Qlik.
What is your expression for Patients seen by Facility? Is it using Count? Then try this
Count([Patients seen by Clinic] / Count(TOTAL [Patients seen by Clinic])
Sunny,
Anytime I use the TOTAL fx, it gives me an Error in expression.
What is your expression my friend?
Sunny,
Yes, I am using a Count to get the distribution of patients seen at each clinic. So for the Patient Seen %, I used the same field, but wanted to get a % instead of a count, to denote as distribution/allocation.
Expression please
This is the actual expression that is being used in the Patients seen by Facility
Count([SEEN BY PROVIDER]) and I get the count which is what is depicted in the screen shot
If I use the following:
Sum([SEEN BY PROVIDER]) - I just get 0.00%
If I use the following:
Sum([SEEN BY PROVIDER])/Sum(Total([SEEN BY PROVIDER]) - I get Error in expression
Try this
Count([SEEN BY PROVIDER])/Count(TOTAL [SEEN BY PROVIDER])
The only way I am getting Total to display in the Table is using the Totals button in the Presentation Tab. If I turn off, then the total goes away
OMG....It Worked!!!!
Sunny Thank You so so much!!!