Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

ccarlock12
New Contributor II

How do I make a Pivot table that is in QLikview appear the same in NPRINT?

I have an attached screen grab of a pivot table in Qlikview that I want to have the same results in NPRINT. I create a pivot table from the table the report comes from and the data never formats the same way. The % percentage calculations either are always 0% or 100%. I would love the format to be the same as what appears in Qlikview and having no luck.

1 Reply
Lech_Miszkiewicz
Honored Contributor III

Re: How do I make a Pivot table that is in QLikview appear the same in NPRINT?

It would be good if you could attach qvw file so i could work on it.

Could you also inlude screenshot or xls file of your outcome from NPrinting

You can do couple of tricks with it depending on what you will use this information for:

  1. Use image instead of data table. That will create table as it is in QV
  2. See whether you have "ticked" checkbox (keep source formatting). Depending on how you would like to have your outcome to be looking like you may want to "uncheck it" and do all formatting in excel. Keep in mind that your values need to be transfered to excel as numbers. They cannot be text"
  3. Export as straight table and create XLS file with pivot table formated to your needs with refresh pivot table on open

Hope this will point you in right direction

regards

Lech

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
Community Browser