topic Re: why my dates are displaying wrong!!! in Qlik NPrinting

why my dates are displaying wrong!!!

Anonymous — Mon, 03 Apr 2017 09:50:54 GMT

hi ,

I have sorted this issue with the sort option by ascending order.

Despite doing the same , the dates are pulling in the pivot table in a wrong order.

How to correct this.

any help is highly appreciated.

Re: why my dates are displaying wrong!!!

hector_munoz — Mon, 03 Apr 2017 10:00:16 GMT

Hi,

Have you ordered it by num? If this is true, do you have a numeric value for months which could be used for numeric sorting?

Regards,

Re: why my dates are displaying wrong!!!

Anil_Babu_Samineni — Mon, 03 Apr 2017 10:04:28 GMT

Are you talking about Excel / With in qlikview. If qlikview there is option - uncheck the y-value option for that field

Re: why my dates are displaying wrong!!!

Mon, 03 Apr 2017 10:04:39 GMT

May be It's Sorting issue just right click on Table go to properties>>Sort option and select Sort option on basis of Numeric Ascending Order like below:

Re: why my dates are displaying wrong!!!

yoganantha321 — Mon, 03 Apr 2017 10:08:10 GMT

shall you share the data in excel and output needed format in same excel

Re: why my dates are displaying wrong!!!

Anonymous — Mon, 03 Apr 2017 10:13:07 GMT

Hi,

All I have is Month/Year (like Nov 2015.......etc)

I was doing a straight table in qlikview and then importing on to the nprinting and pivoting it and I am gettting this problem.

I did correct this behaviour last time, but i am unable to get the dates right this time.

Re: why my dates are displaying wrong!!!

Anonymous — Mon, 03 Apr 2017 10:16:17 GMT

There you go .

this is the output excel file which has been pivoted wrong dates.