Discussion Board for collaboration on Qlik NPrinting.
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
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|
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:
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.
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|