topic Re: Translate a number to a text in QlikView

Translate a number to a text

Wed, 25 Nov 2020 16:16:04 GMT

I have a field that has a number stored in it. I want to display a text. example

when table.field = 60 display Not Started....

Re: Translate a number to a text

sunny_talwar — Tue, 17 May 2016 19:48:15 GMT

May be like thi:

=If(table.field = 60, 'Not Started')

Re: Translate a number to a text

swuehl — Tue, 17 May 2016 20:19:58 GMT

You can use a MAPPING table approach to map your numbers to text:

Mapping … and not the geographical kind

Data Cleansing

Note when reading these blog posts that it doesn't matter what values you are mapping (numbers or Names or Countrys), the mapping table is just a lookup table with Key / Value pairs.