Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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)