Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
raghuvr33
Contributor III
Contributor III

Summarize duplicate rows of data

In one of our reports there are rows in the data that have same values for all the columns except the amount which is the last column, while some rows of data are unique and are not duplicated. Would like to sum the amount for the duplicate data and show one row with all the columns and the sum(amount) in the last column.

Would hate to do this in data model in Qlik sense as this requirement may vary for other reports.  We are using Qlik Sense enterprise and Nprinting 17.6. Is there any way to do this in Nprinting with Excel template???

1 Solution

Accepted Solutions
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi Raghu.

This is little bit strange question as normaly you would have aggregation happening automaticly in Qlik Sense chart. I gues your "amount" column is a dimension and therefore produces multiple rows.

I do not expect you to change your data model, but maybe just create a chart (table) with dimensions you need for nprinting and with measure: sum(amount)?

I don't think there is a better solution for this!

As an alternative you would have to go an create a excel pivot table which does exactly what you are asking for!

https://help.qlik.com/en-US/nprinting/September2017/Content/ExcelReports/HowCreatePivotTableExcelTab...

cheers

Lech

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

2 Replies
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi Raghu.

This is little bit strange question as normaly you would have aggregation happening automaticly in Qlik Sense chart. I gues your "amount" column is a dimension and therefore produces multiple rows.

I do not expect you to change your data model, but maybe just create a chart (table) with dimensions you need for nprinting and with measure: sum(amount)?

I don't think there is a better solution for this!

As an alternative you would have to go an create a excel pivot table which does exactly what you are asking for!

https://help.qlik.com/en-US/nprinting/September2017/Content/ExcelReports/HowCreatePivotTableExcelTab...

cheers

Lech

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
raghuvr33
Contributor III
Contributor III
Author

Agreed. My bad. I had just dragged all the columns from the field list into the table including the numeric. After deleting and adding each column as a dimension and measure with making measure as the sum(..) it worked. I see how it works now.

Thanks Lech.