topic Re: Change Number date to Name in QlikView

Change Number date to Name

Tue, 10 Dec 2013 18:32:37 GMT

I have attempted three different script addons with my data load to get my month dates that currently show 201301, etc to show Jan 2013. How do I do this?

Re: Change Number date to Name

Anonymous — Tue, 10 Dec 2013 18:35:19 GMT

Kari

How about:

MonthName(date#('201301','YYYYMM'))

Best Regards, Bill Markham

Re: Change Number date to Name

vgutkovsky — Tue, 10 Dec 2013 18:35:43 GMT

Try this: date(date#(fieldname,'YYYYMM'),'MMM YYYY')

Regards,

Vlad

Re: Change Number date to Name

Tue, 10 Dec 2013 19:03:30 GMT

try this

Date(Date#(datefield,'YYYYMM'),'MMM YYYY')

Re: Change Number date to Name

Tue, 10 Dec 2013 20:17:05 GMT

Hello,

Try this:

MonthName(MakeDate(Left('201301',4),Right('201301',2),1))

MonthName(MakeDate(Left(Field,4),Right(Field,2),1))

Re: Change Number date to Name

Fri, 13 Dec 2013 18:17:04 GMT

Thanks all but I keep getting and unknown script error. I'm pulling my data from a BWSAP Cube,. I'm not working with a flat file I can manipulate easily. I am thinking it has to do with the base data not having the month name as an option?

Re: Change Number date to Name

Anonymous — Fri, 13 Dec 2013 18:22:37 GMT

Kari

Can you get the basic data from your BWSAP Cube loaded into QlikView without errors?

Ignoring any date format manipulation

If you can then paste your load script into here so we can see it & hopefully make relevant suggestions.

Best Regards, Bill

Re: Change Number date to Name

Fri, 13 Dec 2013 18:25:38 GMT

Yes, my base data loads as it should, error free. It was once I started creating charts that I noticed the dates.

Directory;

LOAD COMP_CODE.COMP_CODE as [Company Code],

NET_WGT_DL as [Net Weight/Vol],

FCNETVALUE as [Net Value Shipment],

DISTANCE,

[/BIC/ZGD_CNT] as Counter,

ZRECPLANT.ZRECPLANT as [Receiving Plant],

ZSHP_PLAN.ZSHP_PLAN as [Shipping Plant],

DEL_TYPE.DEL_TYPE as Delivery ,

SHIP_COND.SHIP_COND as Mode,

[ZCONDTYPE./BIC/ZCONDTYPE],

[ZCONDUNIT./BIC/ZCONDUNIT],

PROFIT_CTR.PROFIT_CTR as [Profit Center],

PLANT.PLANT as Plant,

MATERIAL.MATERIAL as Material,

[ZVEHICLE./BIC/ZVEHICLE],

CURRENCY.CURRENCY as Currency,

FCDOCCRNCY.FCDOCCRNCY,

CALDAY.CALDAY as Day,

CALMONTH.CALMONTH as Month, //Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sept, Oct, Nov, Dec,

CALYEAR.CALYEAR as Year,

FISCPER.FISCVARNT as [Fiscal Variant],

FISCPER.FISCPER as [Fiscal Year Period],

FISCPER3.FISCPER3 as [Fiscal Period],

WEEKDAY1.WEEKDAY1 as Weekday,

[COMP_CODE./BIC/ZGRPCOMP]

I did attempt this as well:

[Calendar]:

load dual(String,Num) as Month inline

[String,Num

Jan,1

Fev,2

Mar,3

Apr,4

May, 5

Jun,6

Jul,7

Aug,8

Sep,9

Oct,10

Nov,11

Dec,12];

Re: Change Number date to Name

Fri, 13 Dec 2013 18:33:13 GMT

Hello,

I've worked with BWSAP and SAP R3 and these formulas works because time format doesn't matter, the data is considered as text

MonthName(MakeDate(Left('201301',4),Right('201301',2),1))

MonthName(MakeDate(Left(Field,4),Right(Field,2),1))

best regards.

Re: Change Number date to Name

Mon, 16 Dec 2013 15:28:32 GMT

Perhaps I am putting it in my script wrong then? When I add this into my script I get an "unknown statement" error - as I did with all the other suggestions.

Re: Change Number date to Name

Mon, 16 Dec 2013 16:09:42 GMT

Hello,

Can you write your script?

Re: Change Number date to Name

Mon, 16 Dec 2013 16:57:49 GMT

its above.- a few threads back... I've tried inserting it at the bottom, next to the desingation of Month as MONTH etc...