topic Re: help with Expresssion in QlikView

help with Expresssion

arusanah — Thu, 21 May 2015 14:41:27 GMT

i am trying to concatenate two fields as

[Payer.Name] &'('& [Payer.Number] &')' as Payer.Name1

this expression is not working for me

Iget output as - ABC(1760)

whereas it should be ABC(1760)

i tried using purgechar(Payer.Name,'-') it replaces ' - ' with ' ' '

trim gives same output as origanal expression one .

can anybody help?

Re: help with Expresssion

sunny_talwar — Thu, 21 May 2015 14:45:05 GMT

Try this may be:

Replace([Payer.Name] &'('& [Payer.Number] &')', '- ', '') as Payer.Name1

Re: help with Expresssion

awhitfield — Thu, 21 May 2015 14:49:36 GMT

Just tried your expression and it looks ok

Data:
Load * Inline
[
Payer.Name, Payer.Number
ABC, 1760
];

Data2:
Load
[Payer.Name] &'('& [Payer.Number] &')' as Payer.Name1
Resident Data
;

Output =

Have you checked your payer.name data? Can you post the source data?

Andy

Re: help with Expresssion

robert_mika — Thu, 21 May 2015 14:51:24 GMT

TextBetween( [Payer .Name],'-','') &'('& Payer.Number &')' as Payer.Name1

Re: help with Expresssion

arusanah — Thu, 21 May 2015 14:58:13 GMT

doesnt work for me

in source Payer Name is - 'ABC'

i tried all functions to get rid of quotes but not working

Re: help with Expresssion

sunny_talwar — Thu, 21 May 2015 14:59:56 GMT

Will you be able to share a sample?

Re: help with Expresssion

antoniotiman — Thu, 21 May 2015 15:09:02 GMT

Try

PurgeChar([Payer.Name],'-'&Chr(39))

Regards,

Antonio

Re: help with Expresssion

vishsaggi — Thu, 21 May 2015 15:19:37 GMT

Hi Arusanah,

If the source contains is definitely - 'ABC' then use below as a work around. Let me know if this works

Load mid(Payer.Name,4,3) & '(' & Payer.Number & ')' As ConcatenatedPayer;