topic Re: Changing 1 and 0 into Yes and No (Dual function) in QlikView

Changing 1 and 0 into Yes and No (Dual function)

Sat, 28 Feb 2015 21:06:27 GMT

HI, please assist with changing the values in this field from 1 and 0 to Yes and No:

prieper — Sat, 28 Feb 2015 21:18:45 GMT

Depending the context,

a simple

IF(Job_Close = 0, 'NO', 'YES')

may do the trick.

Else you may have a look into the mapping-functionality, either APPLYMAP or MAP USING ....

HTH Peter

simospa — Sat, 28 Feb 2015 21:21:30 GMT

Hi Manus,

dual is used specially whe you have to represent many values in a range with a differente string.

You can use, in you load script, somthing like this:

LOAD ...

if(Job_Closed=0,'NO','YES') as J_Closed,

...

and you can then used this field in your filter.

Alternatively you can use for your list box an Expression (last item on field list) and write =if(Job_Closed=0,'NO','YES')

Let me know if it can be adapted to your project.

MK_QSL — Sat, 28 Feb 2015 22:41:43 GMT

IF(Job_Close = 0, Dual ('NO',0), Dual ('YES',1))

Mon, 02 Mar 2015 06:42:21 GMT

Tx Manish, worked like a charm!!!