Skip to main content

Water Cooler

This space is for everyone to ask questions related to the Community Platform. It's a space for us to get to know each other and have some fun! Come in and gather around the Water Cooler!

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
CreoLTD112
Contributor
Contributor

Seperate Months from Field

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

5 Replies
PabloTrevisan
Partner - Creator II
Partner - Creator II

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

HI Thanks

 

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


TIA

PabloTrevisan
Partner - Creator II
Partner - Creator II

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

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
Partner - Creator II
Partner - Creator II

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