Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
eduardo_dimperi
Valued Contributor II

Problem with function SUM()

Hi everyone,

I finally end my code (hope so), and thanks to all that spend some time to help me.

Now the last problem that i dont understand is using the SUN() function in the graphic.

If you look the image for the meter 32646 i only have 1 value 0,17 so when i use SUN(CONSUMO_REAL0), I expect output 0,17.

Why for all saints im getting 2,04 ????

Consumo_real.JPG

1 Solution

Accepted Solutions
parimikittu
Contributor II

Re: Problem with function SUM()

Hi,

The reason for repetiton is due the underlying data modelling.

1) the table which contains OID_METER,Consumo_real0 columns might be joined with other tables, hence causing duplicate records

2)the columns OID_METER and Consumo_real0 might be in different tables and are associated using a common key which might have 12 entries.

12 Replies
Khan_Mohammed
Honored Contributor II

Re: Problem with function SUM()

Cus it is doing sum for all related OID_METER 32646 for CONSUMO_REAL0.

Maybe try Sum(Distinct(CONSUMO_REAL0) ???

Re: Problem with function SUM()

It seems that your data is repeating for some reason. In this particular case the OID_METER might be repeating 12 times (12*0.17 = 2.04). Although you can fix this on the front end of the application, I would suggest fixing this in the back end because you don't want to carry a single row 12 times if you don't have a real use for it

eduardo_dimperi
Valued Contributor II

Re: Problem with function SUM()

Yah, but by the image i have only 4 measures to this meter, 1 =0,17 and 3 = null.

How this sum could be equal 2,04?

Khan_Mohammed
Honored Contributor II

Re: Problem with function SUM()

I don't know how your data is or script is....

Maybe try what Sunny is saying in below reply?

eduardo_dimperi
Valued Contributor II

Re: Problem with function SUM()

Hey Sunny, i saw this 12*0.17, but still dont get why this happen.

About carry a single row 12 times if i dont use SUN() its not occur. I think that will be better use Max() instead SUN()

Re: Problem with function SUM()

You have many options, you can do Only(), Max(), Avg(), Min(), Sum(Distinct...).... but all these are workarounds. None of them solves the underlying issue that you have multiple rows with same information.

eduardo_dimperi
Valued Contributor II

Re: Problem with function SUM()

I agree about thats only workarounds, but why not apear that repeated values when i dont use any agreggation?

agreggation.JPG

Re: Problem with function SUM()

Because a table only show a unique combination of all the fields. If you add another field where the two rows would not match, you will see your multiple rows.

parimikittu
Contributor II

Re: Problem with function SUM()

Hi,

The reason for repetiton is due the underlying data modelling.

1) the table which contains OID_METER,Consumo_real0 columns might be joined with other tables, hence causing duplicate records

2)the columns OID_METER and Consumo_real0 might be in different tables and are associated using a common key which might have 12 entries.