topic Re: Ampersand in text string causing problems in QlikView

Ampersand in text string causing problems

Tue, 10 Dec 2013 10:28:35 GMT

My dataset has a text variable where some of the strings contain ampersands (&). When using the variable in QV, whether its in list boxes or tables, the ampersand cuts off the string. E.g. "A dog & a cat" returns the shown text " a cat".

I have tried using text(varname) as [varname] in Edit script, but without any luck..

Thanks in advance..

Re: Ampersand in text string causing problems

Anonymous — Tue, 10 Dec 2013 10:34:30 GMT

Bruno

Would using the Replace() function to replace the '&' with the text 'and' be acceptable ?

Best Regards, Bill

Re: Ampersand in text string causing problems

Tue, 10 Dec 2013 10:46:57 GMT

Hi Bill,

Thanks, but unfortunately this is not possible as the '&' has to be replaced with different words in different strings (and, AND, the Danish word for 'and'). I cannot know which exact word, whitout going through all strings in the dataset.

Best Regards

Re: Ampersand in text string causing problems

MayilVahanan — Tue, 10 Dec 2013 11:09:10 GMT

Can you provide a sample?

Re: Ampersand in text string causing problems

Anonymous — Tue, 10 Dec 2013 11:24:59 GMT

You can replace & with chr(38) in your string and it will solve your problem.

Regards

Nitin

Re: Ampersand in text string causing problems

Tue, 10 Dec 2013 14:08:29 GMT

I'm sorry, but I can't make it work here (I tried to replace the '&' using the replace function in QV, but I couldn't - not to any other string or sign ..)

However, I found a solution. In my excel-data I replaced '&' with 'chr(38)'. Then when loading into QV I replaced 'chr(38)' with '&'. Peculiarly that worked.

Anayway, thanks all for answering.

Regards

Bruno

Re: Re: Ampersand in text string causing problems

jonathandienst — Tue, 10 Dec 2013 14:56:34 GMT

Bruno

I do not see this behaviour and I would not expect any issues with &. See the attached where I am loading from a spreadsheet column containing cells with &.

Perhaps you should post an example so that we can discover why you are having this issue.

HTH

Jonathan

Re: Ampersand in text string causing problems

Anonymous — Fri, 02 Oct 2015 01:28:30 GMT

thanks for this... I tried it using the same qlikview generator and its displaying properly.

something must be wrong with how my file was encoded...

ok, thanks a lot..