Chart object sum doubles the values, without sum it is correct but need to sum for multiple records

[rpavan17]

Hi,

I have a chart object and it double/triples values at expression when i give Sum(field value). It gives correct value when i give only field value. But, need to sum for multiple rows.

Please help.

[tresesco]

Try if using distinct qualifier helps, like: =Sum( Distinct Value) . However, if this resolves the issue temporarily, that means your data modelling might have an issue and that should be rectified at the first place.

[rpavan17]

Thank You..

It works but it removed few values distant values in sum..

[rpavan17]

Hi,

As you said, the data model might have an issue. How to resolve this.

[tresesco]

That's difficult to tell without knowing your data and many other aspects of modelling. One quick check - check if you have joined tables in your scripting, and if yes, make sure that at least one of the key fields has unique values in one table?

[rpavan17]

Hi,

I have ReportID is unique header ID and which has multiple item level IDs. But, This Report ID repeats for item level as well. So, this ReportID will be unique ID or not?

Thanks!

[rpavan17]

Hi,

I have also observed that few of the rows are not coming to Qlikview from source.

Thanks!