Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
may be I didn't understand your problev, but this qvw (see in attachment) works in v.8.5 too.
Shameless self-bump because I can't figure this out...
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
Neg - Does not work.
what your version of QlikView ?
In 9.0 SR2 I didn't have any problem. Can you post your qvw file?
8.5
I can't post my QVW due to the sensitive nature of its set-up and data.
may be I didn't understand your problev, but this qvw (see in attachment) works in v.8.5 too.
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... )