Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

richardjsmith
New Contributor II

Displaying fields as text which contains numbers

 

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.

 

1 Solution

Accepted Solutions
MVP
MVP

Re: Displaying fields as text which contains numbers

Did you try to load them like a text?

Text(FieldName) as FieldName

3 Replies
MVP
MVP

Re: Displaying fields as text which contains numbers

Did you try to load them like a text?

Text(FieldName) as FieldName

richardjsmith
New Contributor II

Re: Displaying fields as text which contains numbers

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

richardjsmith
New Contributor II

Re: Displaying fields as text which contains numbers

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.

Community Browser