topic Re: How to remove special character in QlikView

How to remove special character

Anonymous — Thu, 01 Mar 2018 11:49:25 GMT

My source like this

Sno, Snd

1,["XXX","RRR \u0026 OOO"]

4,xxx

EXPACTED O/P

we wanrt filter level give snd showing below

Snd listobject level blank is sowhing "NA" chart level it showing blank

Snd

xxx

RRR&OOO

expacted o/p in chart level

Sno,Snd

1,XXX,RRR&OOO

4,XXX

How it will get

Re: How to remove special character

jonathandienst — Thu, 01 Mar 2018 12:00:15 GMT

For a small number of these enitity encoded characters, you could use a mapping table and the MapSubstring command to apply the changes. Like this:

MAP_ENCODINGS:

LOAD * Inline

[

Code, Char

\u0026, &

];

// add more encodings per your requirements

Result:

LOAD Sno,

Snd as Snd_ORIG,

MapSubstring('MAP_ENCODINGS', Snd) as Snd

FROM ....

Re: How to remove special character

Anil_Babu_Samineni — Thu, 01 Mar 2018 12:41:43 GMT

Probably define at least 5 Rows which is not relevant to each

Re: How to remove special character

Anonymous — Thu, 01 Mar 2018 13:01:20 GMT

Hi Anil,

My souece like below...

sno,snd,name

1,["A","b","c\u0026 n"],raju

2,["d","e","f"],ravi

3,,ramu

4,,Nani

I am expacted in list box level

snd

c&n

and chart level

when ever clik on "NA" in lis box

sno,snd,name

1,,raju,

2,,ravi

3,,Ramu

4,,Nani

and when ever select snd listbox inside "A" o/p like below..

sno,snd,name,

1,a,b,c&d.raju

thanks

nani

Re: How to remove special character

Chanty4u — Thu, 01 Mar 2018 13:03:52 GMT

in this output is so many rows?

sno,snd,name

1,["A","b","c\u0026 n"],raju

2,["d","e","f"],ravi

3,,ramu

4,,Nani

I am expacted in list box level

snd

c&n

Re: How to remove special character

Anonymous — Thu, 01 Mar 2018 14:10:31 GMT

yes