topic Function Help in QlikView

Function Help

Wed, 20 May 2015 07:23:45 GMT

My filebaseName() is - SCR-May'15, Now I want to convert the same string in Year Month, i.e.. - May 2015.

Is it possible to convert the same.

Thanks

Gysbert_Wassenaar — Wed, 20 May 2015 07:33:53 GMT

Maybe: replace(subfield(filebasename(),'-',-1), chr(39), ' 20')

PrashantSangle — Wed, 20 May 2015 07:34:17 GMT

Hi,

Use Subfield() and Date#() and Date()

Try like

MonthName(Date#(Subfield(FileBaseName(),'-',2),'MMMYY'))

Note : for removing ' use purgechar(FileBaseName,Chr(39))

Regards

Wed, 20 May 2015 07:53:00 GMT

Hi Max,

Please find the attached xls, I tried but not coming.

Thanks.

robert_mika — Wed, 20 May 2015 07:58:46 GMT

Another way::

=monthname(DATE#(replace(TextBetween (fileBaseName(),'-',''),chr(39),''),'MMMYY'))

PrashantSangle — Wed, 20 May 2015 07:59:40 GMT

MonthName(Date#(Subfield(PurgeChar(YearMonth,chr(39)),'-',2),'MMMYY')) as new_yearMonth

write above in script

Regards

robert_mika — Wed, 20 May 2015 08:01:18 GMT

Directory;

LOAD ProductCode,

SellerCode,

monthname(DATE#(replace(TextBetween (YearMonth,'-',''),chr(39),''),'MMMYY')) as YEarMonth

FROM

TESTDATA.xls

(biff, embedded labels, table is [TB06_20150520_123238$]);