Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

hammermill21
Contributor II

Calculating Total in Table - Qlik Sense

Hello,

I am trying to calculate a total for a table, I need to count all the total across and then divide it by the count of facilities then divide by 3. So for example, the first row should = 67% but it doesn't work.

I tried:

Count([UHealth Tower])+Count([UMHC Applebaum])+Count([UMHC BPEI])+Count([UMHC Coral Spg])+Count([UMHC Deerfield])+Count([UMHC Ear Institute])+Count([UMHC Hollywood])+Count([UMHC IR Clinic])+Count([UMHC Kendall])+Count([UMHC LFMC])+Count([UMHC Marlin Park])+Count([UMHC Pain Clinic])+Count([UMHC Plantation])+Count([UMHC Radiology])+Count([UMHC Safie])+Count([UMHC SCCC])

/

SUM([UHealth Tower])+SUM([UMHC Applebaum])+Sum([UMHC BPEI])+Sum([UMHC Coral Spg])+Sum([UMHC Deerfield])+Sum([UMHC Ear Institute])+Sum([UMHC Hollywood])+Sum([UMHC IR Clinic])+Sum([UMHC Kendall])+Sum([UMHC LFMC])+Sum([UMHC Marlin Park])+Sum([UMHC Pain Clinic])+Sum([UMHC Plantation])+Sum([UMHC Radiology])+Sum([UMHC Safie])+Sum([UMHC SCCC]) /3

Which is counting all the facilities then / by the sum total of each column then / by 3 but it doesn't work.

Tags (2)
1 Solution

Accepted Solutions

Re: Calculating Total in Table - Qlik Sense

Try this

(SUM([UHealth Tower])+SUM([UMHC Applebaum])+Sum([UMHC BPEI])+Sum([UMHC Coral Spg])+Sum([UMHC Deerfield])+Sum([UMHC Ear Institute])+Sum([UMHC Hollywood])+Sum([UMHC IR Clinic])+Sum([UMHC Kendall])+Sum([UMHC LFMC])+Sum([UMHC Marlin Park])+Sum([UMHC Pain Clinic])+Sum([UMHC Plantation])+Sum([UMHC Radiology])+Sum([UMHC Safie])+Sum([UMHC SCCC]))

/

((Count([UHealth Tower])+Count([UMHC Applebaum])+Count([UMHC BPEI])+Count([UMHC Coral Spg])+Count([UMHC Deerfield])+Count([UMHC Ear Institute])+Count([UMHC Hollywood])+Count([UMHC IR Clinic])+Count([UMHC Kendall])+Count([UMHC LFMC])+Count([UMHC Marlin Park])+Count([UMHC Pain Clinic])+Count([UMHC Plantation])+Count([UMHC Radiology])+Count([UMHC Safie])+Count([UMHC SCCC]))/3)

11 Replies

Re: Calculating Total in Table - Qlik Sense

Try this

(

Count([UHealth Tower])+Count([UMHC Applebaum])+Count([UMHC BPEI])+Count([UMHC Coral Spg])+Count([UMHC Deerfield])+Count([UMHC Ear Institute])+Count([UMHC Hollywood])+Count([UMHC IR Clinic])+Count([UMHC Kendall])+Count([UMHC LFMC])+Count([UMHC Marlin Park])+Count([UMHC Pain Clinic])+Count([UMHC Plantation])+Count([UMHC Radiology])+Count([UMHC Safie])+Count([UMHC SCCC])

)

/

(

SUM([UHealth Tower])+SUM([UMHC Applebaum])+Sum([UMHC BPEI])+Sum([UMHC Coral Spg])+Sum([UMHC Deerfield])+Sum([UMHC Ear Institute])+Sum([UMHC Hollywood])+Sum([UMHC IR Clinic])+Sum([UMHC Kendall])+Sum([UMHC LFMC])+Sum([UMHC Marlin Park])+Sum([UMHC Pain Clinic])+Sum([UMHC Plantation])+Sum([UMHC Radiology])+Sum([UMHC Safie])+Sum([UMHC SCCC]) /3

)

hammermill21
Contributor II

Re: Calculating Total in Table - Qlik Sense

So that works better! But the total is wrong, I get 52% when it should be 67%.

Re: Calculating Total in Table - Qlik Sense

Not sure... may be share a sample

hammermill21
Contributor II

Re: Calculating Total in Table - Qlik Sense

Here is my app.

So what I am trying to calculate is the 32 (total sum of row) / 16 (number of facilities) / 3 (highest possible score)

Thank you Sunny!

Re: Calculating Total in Table - Qlik Sense

Try this

(SUM([UHealth Tower])+SUM([UMHC Applebaum])+Sum([UMHC BPEI])+Sum([UMHC Coral Spg])+Sum([UMHC Deerfield])+Sum([UMHC Ear Institute])+Sum([UMHC Hollywood])+Sum([UMHC IR Clinic])+Sum([UMHC Kendall])+Sum([UMHC LFMC])+Sum([UMHC Marlin Park])+Sum([UMHC Pain Clinic])+Sum([UMHC Plantation])+Sum([UMHC Radiology])+Sum([UMHC Safie])+Sum([UMHC SCCC]))

/

((Count([UHealth Tower])+Count([UMHC Applebaum])+Count([UMHC BPEI])+Count([UMHC Coral Spg])+Count([UMHC Deerfield])+Count([UMHC Ear Institute])+Count([UMHC Hollywood])+Count([UMHC IR Clinic])+Count([UMHC Kendall])+Count([UMHC LFMC])+Count([UMHC Marlin Park])+Count([UMHC Pain Clinic])+Count([UMHC Plantation])+Count([UMHC Radiology])+Count([UMHC Safie])+Count([UMHC SCCC]))/3)

hammermill21
Contributor II

Re: Calculating Total in Table - Qlik Sense

Honestly... you are the best!

Thank you!!!!!

hammermill21
Contributor II

Re: Calculating Total in Table - Qlik Sense

Sunny,

If I can ask you another question. My rows have duplicates that with the same total so, therefore, they are being removed from my table.

How can I fix that? I read that it is common but not how to fix it. It's on the same table I was working on.

Re: Calculating Total in Table - Qlik Sense

If I can ask you another question. My rows have duplicates that with the same total so, therefore, they are being removed from my table.

Getting removed while reload or is this in the chart itself?

hammermill21
Contributor II

Re: Calculating Total in Table - Qlik Sense

In the chart itself. But if I do a Count([EC STANDARD]) it will show me I have 8, but on the chart, I only see 3 because the other few have the same totals.

Community Browser