month table

[#1]

hii every one , i loded a table of months ,however they are not in order ....i want themin my tabel  in the normal order (janvier ,fevrier , mars,avril...

[sunny_talwar]

You months might not be read as months by QlikView and read as text. You can use Date#() function to fix the issues. Look here for more details:

Why don’t my dates work?

Get the Dates Right

[#3]

HI sunny actualy i have a table date i want to have only month table , when i used MONTH(DATA_OFFERTA) it s in order however when i used MONTHNAME(DATA_OFFERTA) it's not ???

[sunny_talwar]

MonthName is a dual function and should sort correctly when sorted numerically. If it isn't working, would you be able to share a sample where it isn't working?

[MarcoWedel · Accepted solution]

Salut,

to load your month fields as dual values, keeping the long month names, one solution might be:

tabMOIS:
LOAD Dual(MOIS,Month(Date#(MOIS,'MMMM'))) as MOIS
Inline [
MOIS
janvier
février
mars
avril
mai
juin
juillet
août
septembre
octobre
novembre
décembre
];

You also might have to define the LongMonthNames variable:

SET LongMonthNames='janvier;février;mars;avril;mai;juin;juillet;août;septembre;octobre;novembre;décembre';

hope this helps

regards

Marco

[trdandamudi]

May be like below:

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

Set MonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Month_Table:

Load * Inline [

Month_List

12/01/2016

02/01/2016

01/01/2016

04/01/2016

03/01/2016

06/01/2016

07/01/2016

05/01/2016

08/01/2016

11/01/2016

10/01/2016

09/01/2016

];

Final:

Load  Month(Month_List) as Month,

MonthName(Month_List) as Month_Name

Resident Month_Table;

Drop Table Month_Table;

[#7]

thank you for your reply absolutly helped me