topic Re: month name from textfield in QlikView

month name from textfield

Anonymous — Tue, 17 Apr 2018 12:28:39 GMT

Hello,

I am trying a lot but I dont get it to work. Hopefully someone can help me.

I have a textfield with "Transaction Fees "&Monthname&Year

I want to take the monthname and Year from this field into a new field and convert it to a date.

How can I do this?

Very much thanks for your help in advance.

Chris

Re: month name from textfield

sunny_talwar — Tue, 17 Apr 2018 12:37:36 GMT

May be try this

Date(Date#(PurgeChar(SubField(FieldName, 'Transaction Fees ', -1), ' '), 'MMMYYYY')) as Date

Re: month name from textfield

Anonymous — Tue, 17 Apr 2018 12:49:39 GMT

Hello Sunny,

thank you very much. I think it helped.But only May-Months are shown correctly.

Is it possible, that this has to do with the blanks after the monthname?

I have no idea how much blanks are there.

You have an idea of a solution?

Re: month name from textfield

sunny_talwar — Tue, 17 Apr 2018 12:51:07 GMT

My bad.. I missed the extra M

Date(Date#(PurgeChar(SubField(FieldName, 'Transaction Fees ', -1), ' '), 'MMMMYYYY')) as Date

Re: month name from textfield

Anonymous — Tue, 17 Apr 2018 13:00:08 GMT

Hello Sunny,

it unfortunately did not work. Would you please have a look?

it is in Adyen SettlementReport Line 36

Re: month name from textfield

sunny_talwar — Tue, 17 Apr 2018 13:02:13 GMT

Which tab am I looking at?

Re: month name from textfield

Anonymous — Tue, 17 Apr 2018 13:04:00 GMT

it is in script in Tab Adyen SettlementReport (line 36)

Re: month name from textfield

sunny_talwar — Tue, 17 Apr 2018 13:08:25 GMT

I think your environmental variable is in another language which is why MMMM is unable to recoginze them as months...

SET LongMonthNames='Januar;Februar;März;April;Mai;Juni;Juli;August;September;Oktober;November;Dezember';

Try this

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

Re: month name from textfield

Anonymous — Tue, 17 Apr 2018 13:20:04 GMT

now it worked for june and july.

is it possible to eliminate the blanks between month name and year.

for every monthname they are different 😞

Re: month name from textfield

sunny_talwar — Tue, 17 Apr 2018 13:21:13 GMT

That is what PurgeChar is doing... removing the spaces between Monthname and Year

Re: month name from textfield

Anonymous — Tue, 17 Apr 2018 13:32:10 GMT

Hey Sunny,

thank you very much only an If-Statement was missing