topic Re: Month in QlikView

Month

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

I have month in text format , How do i convert it into a propaer month format ?

sunny_talwar — Tue, 02 Aug 2016 09:39:03 GMT

Do you have January or Jan?

For January, you can try this:

Num(Month(Date#(Month, 'MMMM'))) as MonthNum

For Jan, you can try this

Num(Month(Date#(Month, 'MMM'))) as MonthNum

jpenuliar — Tue, 02 Aug 2016 09:39:41 GMT

have a look here

sunny_talwar — Tue, 02 Aug 2016 09:39:44 GMT

Also make sure that you have the following environmental variables:

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

Mark_Little — Tue, 02 Aug 2016 09:39:55 GMT

Hi,

Depends how exactly is it stored and how do you want to show it.

One answer would be a nested if, but the maybe a simpler answer if you could supply a little more details.

Mark

Chanty4u — Tue, 02 Aug 2016 09:45:22 GMT

try below

if month is Jan,Feb,Mar .....

andfiled is Month

then write

Num(Month) in list

or use in script as

Num(Month) as Monthnum

or else use

inline wizard like below

load * inline

Month,MonthNum

Jan,1

Feb,2

Mar,3

apr,4

;

];

using if(Month='Jan',1,if(Month='Feb',2,if(Month='Mar,3.........))))))))))))