topic Re: month in num to string in QlikView

month in num to string

arulsettu — Thu, 19 Mar 2015 09:23:39 GMT

Hi,

i am having month filed like this

month

i want to convert this in jan,feb,mar......

so used this Month(MakeDate('2014',monthfield)) as newmonth

its working i used this newmonth field to convert quarter but it is not deriving the quarter. also i used this newmonth filed in chart its not giving the result. if i use old month field its giving desired result

any suggestions plz?

Re: month in num to string

sujeetsingh — Thu, 19 Mar 2015 09:29:41 GMT

You can use Wildmatch to give the num months name.

Re: month in num to string

Anonymous — Thu, 19 Mar 2015 09:31:31 GMT

Maybe something like this :

date(MakeDate('2014',monthfield),'MMM')

Re: month in num to string

PrashantSangle — Thu, 19 Mar 2015 09:32:40 GMT

Hi,

Try this,

Date(date#(FieldName,'MM'),'MMM')

Regards

Re: month in num to string

amit_saini — Thu, 19 Mar 2015 09:33:25 GMT

Arul,

Try this:

MonthName:

Mapping

LOAD * INLINE [

F1, F2

January, Jan

February, Feb

March, Mar

April, Apr

May, May

June, Jun

July, Jul

August, Aug

September, Sep

October, Oct

November, Nov

December, Dec

];

MonthNum:

Mapping

LOAD * INLINE [

F1, F2

January, 1

February, 2

March, 3

April, 4

May, 5

June, 6

July, 7

August, 8

September, 9

October, 10

November, 11

December, 12

];

Thanks,

Re: month in num to string

Roop — Thu, 19 Mar 2015 09:33:40 GMT

You can convert it to a date:

Text(Month(Date('01/'&MonthField&'/2015')

It doesn't really matter what year you are using in this syntax.

What is month 0 ?

Re: month in num to string

arulsettu — Thu, 19 Mar 2015 09:36:25 GMT

Hi Max,

its giving the month and quarter but when i use this month in my chart expression result is nothing can u tell me why?

Re: month in num to string

PrashantSangle — Thu, 19 Mar 2015 09:41:13 GMT

Hi,

Just check do you have data for that combination??

and if possible share you sample app.

Regards

Re: month in num to string

hariprasadqv — Thu, 19 Mar 2015 09:41:34 GMT

Try This.

=month(MakeDate(2015,[month]))

Re: month in num to string

arulsettu — Thu, 19 Mar 2015 09:50:30 GMT

PFA

here TBA_CAL_MONTH is old month working in chart

new one is TBAL_month is not working in chart

plz suggest

Re: month in num to string

arulsettu — Thu, 19 Mar 2015 10:05:37 GMT

when i use that converted month the result in chart is gone

can any one suggest why?

thanks

Re: month in num to string

buzzy996 — Thu, 19 Mar 2015 10:31:16 GMT

tested,this one is working...,try this...

=Date(MakeDate(year(today()),month,Day(today())),'MMM')

Re: month in num to string

arulsettu — Thu, 19 Mar 2015 10:33:09 GMT

please check this one in chart

Re: month in num to string

buzzy996 — Thu, 19 Mar 2015 10:47:14 GMT

tht expression written in chart object and tested,it's working.

are u tried? getting any issue?

Re: month in num to string

arulsettu — Thu, 19 Mar 2015 10:51:44 GMT

the expression giving current date. check the sample app

Re: month in num to string

buzzy996 — Thu, 19 Mar 2015 11:10:23 GMT

pfa,sheet4 & main4 script

Re: month in num to string

arulsettu — Thu, 19 Mar 2015 11:14:51 GMT

Hi Siva,

month is not a issue i converted my month into string. issue is converted month is not working in set analysis

plz check above app test(1)(2)

thanks

Re: month in num to string

tresB — Thu, 19 Mar 2015 11:27:01 GMT

Yours doesn't work, because you have created month using date(), that means it holds equivalent date values at the backend.

Instead of,

Date(date#(TBAL_CAL_MONTH,'MM'),'MMM') as TBAL_Month

try like:

Month(date#(TBAL_CAL_MONTH,'MM')) as TBAL_Month

Re: month in num to string

arulsettu — Thu, 19 Mar 2015 11:36:16 GMT

Hi tresesco

its showing the month field in string. but when try to get quarter from this filed its showing only

Q1 and Q4. and the main issue is i want to show last six month values from TBAL_Month. they all are showing zero

plz suggest something

thanks

Re: month in num to string

buzzy996 — Thu, 19 Mar 2015 11:36:30 GMT

can u try to replace this in ur script and try,

Date(MakeDate(year(today()),TBAL_CAL_MONTH,Day(today())),'MMM') as TBAL_Month