why my dates are displaying wrong!!!

[Anonymous]

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.

[hector_munoz]

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

[Anil_Babu_Samineni]

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

[#4]

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:

[yoganantha321]

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

[Anonymous]

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.

[Anonymous]

There you go .

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