topic Re: month table in QlikView

month table

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: month table

sunny_talwar — Fri, 22 Apr 2016 20:48:15 GMT

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

Re: month table

Fri, 22 Apr 2016 21:55:11 GMT

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

Re: month table

sunny_talwar — Fri, 22 Apr 2016 22:32:12 GMT

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?

Re: month table

MarcoWedel — Fri, 22 Apr 2016 22:43:39 GMT

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

Re: month table

trdandamudi — Fri, 22 Apr 2016 22:56:50 GMT

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;

Re: month table

Sun, 24 Apr 2016 14:50:55 GMT

thank you for your reply absolutly helped me