Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
karlykrebs
Contributor III
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.

3 Replies
Anil_Babu_Samineni

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
Contributor III
Contributor III
Author

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

Anil_Babu_Samineni

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)