topic Re: Seperate Months from Field in Water Cooler

Seperate Months from Field

CreoLTD112 — Wed, 02 Jan 2019 07:38:57 GMT

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

Re: Seperate Months from Field

PabloTrevisan — Wed, 02 Jan 2019 18:27:51 GMT

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

Re: Seperate Months from Field

CreoLTD112 — Thu, 03 Jan 2019 05:16:21 GMT

HI Thanks

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

TIA

Re: Seperate Months from Field

PabloTrevisan — Thu, 03 Jan 2019 13:41:56 GMT

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

Re: Seperate Months from Field

CreoLTD112 — Fri, 04 Jan 2019 07:39:58 GMT

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

Re: Seperate Months from Field

PabloTrevisan — Mon, 07 Jan 2019 20:18:20 GMT

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