topic Sort Month from Excel in QlikView

Sort Month from Excel

marciofornari — Sat, 16 Nov 2024 02:08:36 GMT

Hello,

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

the cell is formatted as date

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..

how can i resolve this problem?

Re: Sort Month from Excel

Anonymous — Wed, 23 Oct 2019 13:17:48 GMT

I would use an Inline Table like

CalendarMonth:

load * Inline [

NM_MES, Monthnum

Jan, 1
Fev, 2
...
]

You may use Monthnum in sort order

Re: Sort Month from Excel

Brett_Bleess — Thu, 31 Oct 2019 18:39:08 GMT

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