Discussion Board for collaboration related to QlikView App Development.
my field like below..
where ever null data is there "NA" renaming data coming as usual.
excapted o/p is like below...
aaaaa& Chief Economist for AustraliaNZ
bbbbb &Chief Economist for AustraliaNZ
Hilton Worldwide Holdings
Park Hotels &Resorts Inc - US
check the purgechar function.
you can try like this. add all symbols you want to remove.
You can also add chr(10) for a line break
Not for remove Replace the Character....
o/p like above