11 Replies Latest reply: Jan 4, 2018 2:04 PM by Elizabeth Viso

# 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.

• ###### 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

)

• ###### 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

• ###### 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)

• ###### Re: Calculating Total in Table - Qlik Sense

Honestly... you are the best!

Thank you!!!!!

• ###### 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?

• ###### 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.

• ###### Re: Calculating Total in Table - Qlik Sense

Oh I get it... the straight table/ or table in Qlik Sense shows only distinct combination of the dimensions.... if you think there are multiple rows getting clubbed into one, then add a dimension which will make the combination unique so that all of them show up as separate lines

• ###### Re: Calculating Total in Table - Qlik Sense

I got it!!!

THANK YOUUUUUUUUUUUUUUUUUUUUUU!