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.
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?
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.
Are you talking about Excel / With in qlikview. If qlikview there is option - uncheck the y-value option for that field
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:
shall you share the data in excel and output needed format in same excel
There you go .
this is the output excel file which has been pivoted wrong dates.
Retrieving data ...