Displaying fields as text which contains numbers

[RichardSmith]

We have an issue when displaying fields as text which contains numbers.

e.g. 000023850 is loaded into a field and 023850 is loaded into the same field.

On the reports, we want these to be displayed as 000023850 and 023850. However, they both appear as 000023850

I understand why this is happening as it’s explained in the QlikSense Help…

When several data items read into one field have different string representations but the same valid number representation, they will all share the first string representation encountered.

We’ve tried various workarounds using string manipulation, such as adding a character before the number and then removing it when displaying it, but nothing has worked.

Any help will be appreciated please.

[sunny_talwar · Accepted solution]

Did you try to load them like a text?

Text(FieldName) as FieldName

[RichardSmith]

Yes, I have tried it thanks, but still gave the same result.

[RichardSmith]

Hi Sunny, just letting you know that Text(FieldName) as FieldName did work as you suggested, so thanks for that! Must have coded it wrong somehow when I initially tried it.