topic Re: Concat string in QlikView

Concat string

Fri, 16 May 2014 13:59:46 GMT

Hello,

I want to concatenate two string which are the month and the year of a date named DateFacture, which is a field in my table, to obtain other field, I tried this with two methods but I have always an error!

for example: dateFacture=01/02/2014 , the result is: Mois Année Facture=022014

SubField(DateFacture,'/',2) & '' & SubField(DateFacture,'/',3) as [Mois Année Facture],

or:

Concat(SubField(DateFacture,'/',2) , SubField(DateFacture,'/',3))as [Mois Année Facture],

help me please

Re: Concat string

crusader_ — Fri, 16 May 2014 14:05:59 GMT

Hi,

Just use functions Year(Date), Month(Date), Day(Date).

Hope this helps.

Andrei

Re: Concat string

Fri, 16 May 2014 14:09:39 GMT

Month(DateFacture) & Year(DateFacture) as NewField

Re: Concat string

Fri, 16 May 2014 14:12:24 GMT

Hi,

Thank you, it helps but teh result is oct.2007

how can I convert day in number?

Re: Concat string

jonathandienst — Fri, 16 May 2014 14:14:09 GMT

Assuming DateFacture is a date:

=Text(Date(DateFacture, 'MMYYYY'))

HTH

Jonathan

Re: Concat string

Fri, 16 May 2014 14:14:57 GMT

Please use

Num(Month(DateField))&Year(DateField) as ConcatField

Re: Concat string

Anonymous — Fri, 16 May 2014 14:20:37 GMT

There is no need to concat. If you date is in the fotmat DD/MM/YYYY, just present it in another way:

date(date#(DateFracture, 'DD/MM/YYYY'), 'MMYYYY')

Re: Concat string

Fri, 16 May 2014 14:33:40 GMT

Hi,

all of your response are correct, Thank for you all