Changing Field Values

[#1]

G'day!

We are importing values for a Business Unit, it uses an ampersand ('&') and when the value is used in a chart it produces this ('&').

Example: If the value = 'A & B' then the chart will present 'A & B'.

1) What causes this?
2) How do I fix it?
3) If I can't 'fix' it how can I write a script to identify the "&" and replace it with a "&" as intended.

Cheers;

Kieran Boyce!

[#2]

Shameless self-bump because I can't figure this out...

[sparur]

Hello Kieran.

try to use text() function when ypu load your value. for example:

LOAD

field1, field2,

text([Busiuness Unit]) AS BusinessUnit,

.....

FROM....

I don't tested it, but I think it will help you

[#4]

Neg - Does not work.

[sparur]

what your version of QlikView ?

In 9.0 SR2 I didn't have any problem. Can you post your qvw file?

[#6]

8.5

I can't post my QVW due to the sensitive nature of its set-up and data.

[sparur · Accepted solution]

may be I didn't understand your problev, but this qvw (see in attachment) works in v.8.5 too.

[#8]

Thank you for your reply...

It wasn't a QV error or limitation... it was my fault for not checking the Data Extract we use for reporting...

It was the PM tool we use spitting out & instead of &.

I found it because I looked through your input and table load and it just 'Qliked'... (Lame... I know... )