Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

month table

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

Capture.PNG

1 Solution

Accepted Solutions
MarcoWedel

Salut,

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

QlikCommunity_Thread_214288_Pic1.JPG

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

View solution in original post

6 Replies
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

Not applicable
Author

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

Capture&.PNG&.PNG

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

Salut,

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

QlikCommunity_Thread_214288_Pic1.JPG

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
Master II
Master II

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;

Not applicable
Author

thank you for your reply absolutly helped me