Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

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

View solution in original post

4 Replies
prieper
Master II
Master II

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

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.

S.

MK_QSL
MVP
MVP

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

View solution in original post

Not applicable
Author

Tx Manish, worked like a charm!!!