Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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
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:
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 ???
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?
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
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;
thank you for your reply absolutly helped me