How to change number to text?

[Breezy]

Qlik Cloud

I am making a table and I noticed one of the columns has the content aligned improperly. This is because it has a number in each cell so Qlik thinks those are numbers for math. However, they are numbers to identify dogs. For example: the title is "Dog" and the number 2 means dog number 2. 

How do I change this to 'text' format? 

[Zapparoli · Accepted solution]

Hi, Breezy.

To convert a number to a text format you can use the Text() function.

https://help.qlik.com/en-us/sense/May2023/Subsystems/Hub/Content/Sense_Hub/Scripting/InterpretationF...

Let me know if it helped.

- Matheus

[Breezy]

Thanks Matheus! That was a quick fix.