Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
rpavan17
Creator
Creator

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

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.

6 Replies
tresesco
MVP
MVP

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
Creator
Creator
Author

Thank You..

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

rpavan17
Creator
Creator
Author

Hi,

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

tresesco
MVP
MVP

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
Creator
Creator
Author

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
Creator
Creator
Author

Hi,

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

Thanks!