topic nprinting pivot table in Qlik NPrinting

nprinting pivot table

anirudhrao92 — Tue, 02 Jul 2019 08:31:36 GMT

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

Re: nprinting pivot table

Eva_B — Wed, 14 Aug 2019 23:28:05 GMT

Hello,

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:

https://community.qlik.com/t5/Qlik-Sense-App-Development/Create-pivot-table-measure-not-aggregated-across-columns/td-p/1237575

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

Regards,

Eva

Re: nprinting pivot table

Lech_Miszkiewicz — Thu, 15 Aug 2019 00:07:39 GMT

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!