Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
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
MVP & Luminary
MVP & Luminary

Try to load them as text, like:

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

- Marcus