Discussion Board for collaboration related to QlikView App Development.
Hi! I have a Supplier Number field that is including invisible quotes when exported to Excel (see screenshot below). How can I get these quotes removed?
The field is pulled in as text(Supplier_Number) as Supplier_Number
and displayed in a chart as a dimension: SubStringCount('|' & Concat(distinct %Dimensions, '|') & '|', '|Supplier Number|')
The field does contain alphanumeric values.
Can you try this?
Trim(Replace(Text(Supplier_Number), Chr(34), ' ')) as Supplier_Number
Hi Anil, thanks for the suggestion! But, I'm still getting the same issue.
Can you provide sample to demonstrate the issue?