Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
karlykrebs
New Contributor III

Formating Field

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.

Tags (1)
3 Replies

Re: Formating Field

Can you try this?

Trim(Replace(Text(Supplier_Number), Chr(34), ' ')) as Supplier_Number

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
karlykrebs
New Contributor III

Re: Formating Field

Hi Anil, thanks for the suggestion! But, I'm still getting the same issue.

Re: Formating Field

Can you provide sample to demonstrate the issue?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)