Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
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)