Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor

Current year data not coming in nprinting

Hi

i have a data for business desc, Region, Year and Sales and creating the report for Current/Prev year sales using set analysis in qlik view and its working fine.
but bringing the same thing on to NPrinting, when i select Year 2015, so i am not able to get the data for 2015 Business Desc 'A'
pl. see Qlik View and Nprinting files

6 Replies
Highlighted
Support
Support

Re: Current year data not coming in nprinting

Hi Rajaiah,

I have recreated your QlikView NPrinting PixelPerfect report template as required. Here is a screen shot of the resultant report.

Please expand the attached project to folder C:\Temp\Community\028 to preserve the paths used or change them in the NSQ.

HTH - Daniel.

Highlighted
New Contributor

Re: Current year data not coming in nprinting

Hi Thanks for reply.

actually i am looking in hirarchy format.

here is the my required output

   

RegionPrvious SalesCurr Sales
A180
Noth100
South80
B1127
Noth512
South615
C2826
Noth1310
South1516
Grand Total5753
Highlighted
Support
Support

Re: Current year data not coming in nprinting

Hi,

PixelPerfect does not support Pivot Tables. I suggest you use Excel instead and specify the output as PDF in the report task.

Project attached. Extract to C:\Temp\Community\028

Here are links to a couple of tutorials that show you how to create Pivot Tables in QlikView NPrinting Excel reports:

How to Create an Excel PivotTable Report

How to Create a Pivot Table from Excel Table Columns

Run the report task to generate the report. You can use all the Excel formatting options as required. Here is a screen shot of the PDF:

HTH - Daniel.

Highlighted
New Contributor

Re: Current year data not coming in nprinting

thanks danial.

its working fine.

but it doesn't have much control on sub total/grand total level, like get distinct count etc..

its always summing up, is there any way we can get distinct count, here is the example.

   

RegionPrev PolicyCountCurr PolicyCount
A55
NorthABC103ABC103
SouthABC103ABC103
NorthABC104ABC104
SouthABC115ABC115
NorthABC116ABC116
SouthABC115ABC115
SouthABC117ABC117
B45
NorthABC104ABC104
SouthABC104ABC105
SouthABC105ABC105
NorthABC105ABC106
SouthABC106ABC107
NorthABC107ABC108
NorthABC107ABC107
C45
NorthABC105ABC104
SouthABC010ABC105
SouthABC011ABC010
SouthABC012ABC011
NorthABC012ABC012
Grand Total1012
New Contributor

Re: Current year data not coming in nprinting

can someone through some light on this issue.

Highlighted
New Contributor

Re: Current year data not coming in nprinting

is nprinting supporting these kind of issues ?