Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Sort Month from Excel

Hello,

I have a excel file where the cell is the Month: JAN, FEV, MAR.. 

the cell is formatted as date

Screen Shot 2019-10-23 at 9.51.09 AM.png

My Load is

LOAD DATE,
     NM_MES,
FROM
$(CQVD)\calendario.xlsx
(ooxml, embedded labels, table is CALENDAR); 

The problem is that qlikview not sort by order..

Screen Shot 2019-10-23 at 9.58.54 AM.png

 

how can i resolve this problem?

 

Labels (2)
2 Replies
Highlighted
Partner
Partner

Re: Sort Month from Excel

I would use an Inline Table like

CalendarMonth:

load * Inline [

NM_MES, Monthnum

Jan, 1
Fev, 2
...
]

You may use Monthnum in sort order

Highlighted
Digital Support
Digital Support

Re: Sort Month from Excel

Marcio, did the post help you get things working as you wanted?  If so, please be sure to come back to the thread and use the Accept as Solution button to mark that post as the solution and give credit to the poster for the help.  If you are still working on things, please leave an update, but that solution should be the easiest way to get things as you want them from what I know.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.