Auto and Sum in KPI

[Akkansha_C]

I want to show measure which i have already used in the table. In that table, for measure i have use

total Function as 'Auto'. as per the user its correct value.

I am using the same measure in KPI, but its showing mismatched in values.

When I use Total Function as 'Sum' in table, then the values are matching. (I dont want this value in the table)

[poklegoguy]

Can you provide more details or perhaps take screenshots of the mismatch that you are mentioning?

[Akkansha_C]

hi,

I have applied 'Auto' as Total Function in table. and as per user 214 is correct answer. I have created KPI with same expression which is mentioned in the table, I got 215 as output. If i download this table then also it shows 215 as total sum.

But If i applied 'Sum' as Total Function, then i got 215 as output which is matching with KPI value. 

Then which value is correct?

Spoiler

[HeshamKhja1]

Hi @Akkansha_C ,

I encountered such a behavior before. In my case, my table had a dimension which had null values and I unticked include null values in the dimension. This made the whole row disappear from the table and thus the value of that row was not being calculated in the table measure total. But when you add the measure in a KPI, it brings all values in data resulting in a different number.

Hope my explanation was clear. Let me know if your case is similar to mine.

[Digvijay_Singh]

sometimes the way expression is built in relation to table dimensions makes the difference, to exactly match values between table total and KPI, the KPI need to change like Sum(Aggr(<your table expression>,<table dimensions>)

There are many similar posts in community, one of them as below - 

https://community.qlik.com/t5/New-to-Qlik-Analytics/KPI-Count-not-matching-straight-table/td-p/17789...