topic Re: why my dates are showing wrong? in Qlik NPrinting https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286829#M15154 <HTML><HEAD></HEAD><BODY><P>I think while re-creating the pivot in NPrinting you need to sort the data ....</P></BODY></HTML> Wed, 01 Mar 2017 13:19:01 GMT avinashelite 2017-03-01T13:19:01Z why my dates are showing wrong? https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286825#M15150 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I did as per the tutorial doing the pivot in nprinting.</P><P>But my dates are showing wrong.</P><P>How to correct this.</P><P>Any help pls.</P><P><IMG alt="services.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/154871_services.png" style="height: 496px; width: 620px;" /></P></BODY></HTML> Wed, 01 Mar 2017 13:07:27 GMT https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286825#M15150 Anonymous 2017-03-01T13:07:27Z Re: why my dates are showing wrong? https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286826#M15151 <HTML><HEAD></HEAD><BODY><P>Is the chart correctly sorted in QlikView or Qlik Sense where ever you are getting the chart from?</P></BODY></HTML> Wed, 01 Mar 2017 13:12:11 GMT https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286826#M15151 sunny_talwar 2017-03-01T13:12:11Z Re: why my dates are showing wrong? https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286827#M15152 <HTML><HEAD></HEAD><BODY><P>I am not sure . It looks it is fine.</P><P>Here is the properties i have used in the qlikview<IMG alt="services.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/154872_services.png" style="height: 496px; width: 620px;" /></P></BODY></HTML> Wed, 01 Mar 2017 13:15:47 GMT https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286827#M15152 Anonymous 2017-03-01T13:15:47Z Re: why my dates are showing wrong? https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286828#M15153 <HTML><HEAD></HEAD><BODY><P>This is straight table, right? But you are exporting the pivot table, isn't it?</P></BODY></HTML> Wed, 01 Mar 2017 13:18:44 GMT https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286828#M15153 sunny_talwar 2017-03-01T13:18:44Z Re: why my dates are showing wrong? https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286829#M15154 <HTML><HEAD></HEAD><BODY><P>I think while re-creating the pivot in NPrinting you need to sort the data ....</P></BODY></HTML> Wed, 01 Mar 2017 13:19:01 GMT https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286829#M15154 avinashelite 2017-03-01T13:19:01Z Re: why my dates are showing wrong? https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286830#M15155 <HTML><HEAD></HEAD><BODY><P>Yes this is straight table.</P><P>In order to get pivot in nprinting .I have to use straight table as per the document.</P></BODY></HTML> Wed, 01 Mar 2017 13:20:15 GMT https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286830#M15155 Anonymous 2017-03-01T13:20:15Z Re: why my dates are showing wrong? https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286831#M15156 <HTML><HEAD></HEAD><BODY><P>How do you do that?</P></BODY></HTML> Wed, 01 Mar 2017 13:20:41 GMT https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286831#M15156 Anonymous 2017-03-01T13:20:41Z Re: why my dates are showing wrong? https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286832#M15157 <HTML><HEAD></HEAD><BODY><P>I am new to nPrinting (little over 1 month of experience <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />), curious to know which document says this?</P></BODY></HTML> Wed, 01 Mar 2017 13:22:14 GMT https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286832#M15157 sunny_talwar 2017-03-01T13:22:14Z Re: why my dates are showing wrong? https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286833#M15158 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/docs/DOC-8420">How to Create a Pivot Table from Excel Table Columns</A></P></BODY></HTML> Wed, 01 Mar 2017 13:25:02 GMT https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286833#M15158 Anonymous 2017-03-01T13:25:02Z Re: why my dates are showing wrong? https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286834#M15159 <HTML><HEAD></HEAD><BODY><P>Check for the option in Excel ..while converting into excel check the data properties ..that is the only option I guess </P></BODY></HTML> Wed, 01 Mar 2017 13:27:00 GMT https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286834#M15159 avinashelite 2017-03-01T13:27:00Z Re: why my dates are showing wrong? https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286835#M15160 <HTML><HEAD></HEAD><BODY><P>check this </P><P><A href="https://community.qlik.com/docs/DOC-13947">How to Create an Excel PivotTable Report</A></P></BODY></HTML> Wed, 01 Mar 2017 13:27:40 GMT https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286835#M15160 avinashelite 2017-03-01T13:27:40Z Re: why my dates are showing wrong? https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286836#M15161 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Wed, 01 Mar 2017 13:28:29 GMT https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286836#M15161 sunny_talwar 2017-03-01T13:28:29Z Re: why my dates are showing wrong? https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286837#M15162 <HTML><HEAD></HEAD><BODY><P>I sorted out finally.</P><P>thanks.</P></BODY></HTML> Wed, 01 Mar 2017 13:39:32 GMT https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286837#M15162 Anonymous 2017-03-01T13:39:32Z Re: why my dates are showing wrong? https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286838#M15163 <HTML><HEAD></HEAD><BODY><P>Good , did the option I mentioned helped you ? or you achieved it using any other technique <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Wed, 01 Mar 2017 13:53:18 GMT https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286838#M15163 avinashelite 2017-03-01T13:53:18Z Re: why my dates are showing wrong? https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286839#M15164 <HTML><HEAD></HEAD><BODY><P>your suggestion helped me and I have used data---&gt; sort options and used 'ascending order' that will sort automatically all the dates.</P><P>Thank you indeed.</P></BODY></HTML> Wed, 01 Mar 2017 16:33:45 GMT https://community.qlik.com/t5/Qlik-NPrinting/why-my-dates-are-showing-wrong/m-p/1286839#M15164 Anonymous 2017-03-01T16:33:45Z