Current year data not coming in nprinting

[Anonymous]

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

[Daniel_Jenkins]

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.

[Anonymous]

Hi Thanks for reply.

actually i am looking in hirarchy format.

here is the my required output

Region	Prvious Sales	Curr Sales
A	18	0
Noth	10	0
South	8	0
B	11	27
Noth	5	12
South	6	15
C	28	26
Noth	13	10
South	15	16
Grand Total	57	53

[Daniel_Jenkins]

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.

[Anonymous]

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.

Region	Prev PolicyCount	Curr PolicyCount
A	5	5
North	ABC103	ABC103
South	ABC103	ABC103
North	ABC104	ABC104
South	ABC115	ABC115
North	ABC116	ABC116
South	ABC115	ABC115
South	ABC117	ABC117
B	4	5
North	ABC104	ABC104
South	ABC104	ABC105
South	ABC105	ABC105
North	ABC105	ABC106
South	ABC106	ABC107
North	ABC107	ABC108
North	ABC107	ABC107
C	4	5
North	ABC105	ABC104
South	ABC010	ABC105
South	ABC011	ABC010
South	ABC012	ABC011
North	ABC012	ABC012
Grand Total	10	12

[Anonymous]

can someone through some light on this issue.

[Anonymous]

is nprinting supporting these kind of issues ?