Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
dezmundw15
New Contributor III

Re: Calculate a percentage

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.

Re: Calculate a percentage

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])

dezmundw15
New Contributor III

Re: Calculate a percentage

Sunny,

Anytime I use the TOTAL fx, it gives me an Error in expression.

Re: Calculate a percentage

What is your expression my friend?

dezmundw15
New Contributor III

Re: Calculate a percentage

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.

Re: Calculate a percentage

Expression please

dezmundw15
New Contributor III

Re: Calculate a percentage

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

Re: Calculate a percentage

Try this

Count([SEEN BY PROVIDER])/Count(TOTAL [SEEN BY PROVIDER])

dezmundw15
New Contributor III

Re: Calculate a percentage

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

dezmundw15
New Contributor III

Re: Calculate a percentage

OMG....It Worked!!!!

Sunny Thank You so so much!!!