Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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 |
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.
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 |
can someone through some light on this issue.
is nprinting supporting these kind of issues ?