Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Translate a number to a text

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....

2 Replies

Re: Translate a number to a text

May be like thi:

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


Re: Translate a number to a text

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.