Error message while creating Pivot table in Nprinting Excel

konidena — Thu, 07 Jun 2018 14:02:56 GMT

Hi Team,

I am working on creation of Pivot table in Excel template in Nprinting november 2017.

I have 10 dimensions and 1 measure . I created the table with the this details in Qliksense and pulled it into nprinting table node in excel template.

added all this columns into excel sheet1 and create the formula as below.

Offset(sheet1!$A$1,0,0,CountA(Sheet1!$K:$K),11)

Then I clicked on Insert tab in the excel ribbon and clicked on Pivot table.

Given the table/Range value as "Pivot" --> this is the name i given to the above created formula. and given Ok to create the pivot table in new sheet.

In the Pivot table sheet, I dragged the measure into values box. I tried to convert the aggregation function to Sum but it is showing the following error.

My main requirement is , I need to get the pivot table for the dynamic range of data. That is the reason i created the range formula with offset function.

Below is the error.

Please help to resolve this issue.

Regards

srinivas

Re: Error message while creating Pivot table in Nprinting Excel

konidena — Fri, 22 Jun 2018 12:04:40 GMT

Got the solution. Just need to uncheck the option "Add this data to the data model" in Create Pivot Table window. Then user can select the aggregated function

Regards

Srinivas

topic Error message while creating Pivot table in Nprinting Excel in Qlik NPrinting

Error message while creating Pivot table in Nprinting Excel

Re: Error message while creating Pivot table in Nprinting Excel