Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

jvk_sharma
Contributor III

why my dates are displaying wrong!!!

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.

services.png

6 Replies
hector_munoz_in
Valued Contributor

Re: why my dates are displaying wrong!!!

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,

H

Re: why my dates are displaying wrong!!!

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

Not applicable

Re: why my dates are displaying wrong!!!

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:Test111.JPG

yoganantha321
Contributor II

Re: why my dates are displaying wrong!!!

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

jvk_sharma
Contributor III

Re: why my dates are displaying wrong!!!

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.

jvk_sharma
Contributor III

Re: why my dates are displaying wrong!!!

There you go .

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

Community Browser