I did as per the tutorial doing the pivot in nprinting.
But my dates are showing wrong.
How to correct this.
Any help pls.
Is the chart correctly sorted in QlikView or Qlik Sense where ever you are getting the chart from?
I am not sure . It looks it is fine.
Here is the properties i have used in the qlikview
This is straight table, right? But you are exporting the pivot table, isn't it?
Yes this is straight table.
In order to get pivot in nprinting .I have to use straight table as per the document.
I am new to nPrinting (little over 1 month of experience ), curious to know which document says this?
How to Create a Pivot Table from Excel Table Columns
Oh so you want the Excel Pivot table chart? A direct extract of QlikView's pivot table is not going to work? Cause I feel like if you don't need Excel's pivot table, then an export of QlikView's Pivot table might help resolve your issue here.
How to Create an Excel PivotTable Report
I think while re-creating the pivot in NPrinting you need to sort the data ....
How do you do that?
Check for the option in Excel ..while converting into excel check the data properties ..that is the only option I guess
I sorted out finally.
Good , did the option I mentioned helped you ? or you achieved it using any other technique
your suggestion helped me and I have used data---> sort options and used 'ascending order' that will sort automatically all the dates.
Thank you indeed.
Retrieving data ...