topic Dates to Months? in QlikView

Dates to Months?

knightwriter — Fri, 20 Mar 2015 09:21:29 GMT

Hi All,

I have a query on how I get all the dates (shown below) to show as a selection month. Any help is much appreciated.

Best,

Stephen

28/06/1999 to show as a June etc

Re: Dates to Months?

PrashantSangle — Fri, 20 Mar 2015 09:25:04 GMT

Hi,

USe

MonthNAme()

Month()

Regards

Re: Dates to Months?

PrashantSangle — Fri, 20 Mar 2015 09:26:12 GMT

Hi,

Try

Date(DateField,'MMMM')

Regards

Re: Dates to Months?

Fri, 20 Mar 2015 09:26:38 GMT

hi,

not so clear but you can use date function

Date(date,'DD/MMM/YYYY'- 28/JUN/1999)

Date(date,'DD/MM/YYYY')

date('28/06/1999','DD/MMM/YYYY') as Date

date(Today(),'DD/MMM/YYYY'),

month(date(Today(),'DD/MMM/YYYY'))

month(Today())

Regards

Vimlesh

Re: Dates to Months?

rajkumarb — Fri, 20 Mar 2015 09:27:06 GMT

Stephen

use this

Month(yourdatefield) As Monthname

Month( Date#( yourdatefield,'MMM') ) as Monthname,

Re: Dates to Months?

knightwriter — Fri, 20 Mar 2015 09:29:18 GMT

Hi max dreamer,

Thanks for the but where do I put MonthNAme()?

Cheers

Re: Dates to Months?

PrashantSangle — Fri, 20 Mar 2015 09:32:27 GMT

Hi,

If you are trying it in script.

MonthName(DateField) as MonthYear

Month(DateField) as MonthNumber

Date(DateField,'MMMM') as MonthName

Regards

Re: Dates to Months?

buzzy996 — Fri, 20 Mar 2015 09:37:53 GMT

use this,

Month(urdatefield) as Month

Re: Dates to Months?

knightwriter — Fri, 20 Mar 2015 09:42:51 GMT

Hi All,

Many thanks for all your replies. I am not familiar with editing the scripts, is there a way I can do this in the multi box properties?

Re: Dates to Months?

PrashantSangle — Fri, 20 Mar 2015 09:52:05 GMT

Hi,

In MultiBox->Add as Expression

->MonthName(Activity.Duration)

->MonthName(Activity.External)

and so on

Regards

Re: Dates to Months?

buzzy996 — Fri, 20 Mar 2015 09:52:56 GMT

right clik on ur multibox-properties-General tab-click EDIT -PAST THIS WITH UR DATE FIELD--

Month(urdatefield)

Re: Dates to Months?

PrashantSangle — Fri, 20 Mar 2015 09:53:22 GMT

Hi,

If you want only Month

Then write expression

->Date(Activity.Duration,'MMMM')

->Date(Activity.External,'MMMM')

Regards

Re: Dates to Months?

knightwriter — Fri, 20 Mar 2015 10:07:05 GMT

Thank again, this worked. Next problem!

Now you can see I have a list of one month many times. I want my end result to be a calendar, ie select July and my stats now show all July as a whole and not just one day.

Re: Dates to Months?

PrashantSangle — Fri, 20 Mar 2015 10:26:37 GMT

Hi,

Use Date(MonthStart(FieldName),'MMMM')

Regards