Qlik Community

Ask a Question

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

nprinting pivot table


Can we put no aggregation for a value in Pivot table 


there are sum,average,count all but i dont want anything it should take data as it is from source

Labels (1)
2 Replies


Can you please provide the versions you are using for Qlik NPrinting / Qlik Sense as well as some sample data?

Currently I found a way to do this with QlikView using Calculated Dimensions. 

Please see the following Community Post:


It sounds like you may need to do this in Qlik Sense within the Load Script rather than the NPrinting Report.




Hi Eva @Eva_B ,

This question seems to relate to excel template and excel pivot tables where you only have listed aggregation functions and if this is a case i do not know how to build it.

In QlikView or Qlik Sense it is piece of cake as you can use Concat or Only or Aggr functions to build without issues. Those fucntions will take care of data which cannot be aggregated (like text...)

The author of this question needs to deliver us more information what he/she tries to do and as @Eva_B  said ALWAYS provide versions of software we discuss!

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.