Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
a_bl
Contributor
Contributor

"Numbers" (names that are mostly numbers) containing the letter e not displayed

Hello,

as part of our board we are displaying what you could call product numbers or identifiers and they can have several different formats. The problem is, that some of them look like this one: 200201E00000309

Because the KPI field we show this is thinks this is purely a number, the E is interpreted incorrectly and the field shows nothing, because the "number" is too large. We have so far not found any way to fix is, except add letters in front using" '...' & " but this is not ideal for us.

If anyone knows how we might change it to not do this, it would be appreciated!

1 Reply
marcus_sommer

Try to load them as text, like:

...
text([product numbers]) as [product numbers]
...

- Marcus