topic Changing Field Values in QlikView

Changing Field Values

Wed, 07 Apr 2010 01:17:02 GMT

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!

Fri, 09 Apr 2010 06:59:11 GMT

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

sparur — Fri, 09 Apr 2010 07:18:20 GMT

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

Fri, 09 Apr 2010 07:40:41 GMT

Neg - Does not work.

sparur — Fri, 09 Apr 2010 07:45:55 GMT

what your version of QlikView ?

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

Fri, 09 Apr 2010 07:48:18 GMT

8.5

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

sparur — Fri, 09 Apr 2010 07:58:21 GMT

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

Fri, 09 Apr 2010 08:42:28 GMT

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... )