Seperate Months from Field

[CreoLTD112]

Hi All Fairly new here..

Just wanting to find out how would i go about achieving the following:

I have a field named TIme , withing that is the following 

01 Apr 2018 , 11:19:59 PM

01 Apr 2018 , 11:20:22 PM

01 Apr 2018 , 11:20:24PM

02 Apr 2018 , 11:19:59 PM

05 Apr 2018 , 11:19:59 PM

01 May2018 , 11:19:59 PM etc,etc

This holds 11 months Jan>Nov

I need to create seperate fields for each month to add them to straight table e.g:

Jan|  Feb|  Mar|  Apr| ....

I do not require the times or date just months in order to align my data to the specific month, how would i go about achieving this?

Thanks

[PabloTrevisan]

Hi ! Try this in script: Date(Datefield,'MM') as month or if you want month name try month(Datefield) as month

[CreoLTD112]

HI Thanks

I have loaded the script however nothing seems to populate, any idea why? 

TIA

[PabloTrevisan]

Hi, maybe the format of the field has not been accept, could you send me the qvf ?

[CreoLTD112]

Hi I ave created this template...

What i require is the following :

Under Field: 

[Address]Country--  if 50 changes were made in Jan for ([Address]Country) i need  seperate fields such as Jan|Feb|Mar.. underlying how many changes where made for each month

Of which all data should be within one Straight Table..

Just cannot figure out how..

[PabloTrevisan]

Sorry I don't have qlikview license, could you send me in qvf (Qliksense) format ?