topic Displaying fields as text which contains numbers in App Development

Displaying fields as text which contains numbers

RichardSmith — Thu, 21 Jun 2018 10:12:31 GMT

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.

Re: Displaying fields as text which contains numbers

sunny_talwar — Thu, 21 Jun 2018 15:11:54 GMT

Did you try to load them like a text?

Text(FieldName) as FieldName

Re: Displaying fields as text which contains numbers

RichardSmith — Fri, 22 Jun 2018 10:49:12 GMT

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

Re: Displaying fields as text which contains numbers

RichardSmith — Tue, 03 Jul 2018 07:51:04 GMT

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.