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
This did not work?
Count([SEEN BY PROVIDER])/Count(TOTAL [SEEN BY PROVIDER])
Would you be able to share a smaple?
Good, now please close this thread by marking correct and helpful responses.
Best,
Sunny
Please mark responses which truly helped you and not your 'Thank you' . I ask you to do this is do that future visitors can find this information useful in the future when they land on this page.