How to formulate SQL Query structure to give "YES" or "NO" values for use in Multi-box

[#1]

Greetings.

I am trying to create a simple multi-box, which contains two fields.

Each field would have a value of either YES or NO, depending on whether the value in the SQL database is either "1" or "0"

This is the Script I am using :

CUSTOMERS:

LOAD

(field_1 = '1' ) as field_1_YES,

(field_2 = '1' ) as field_2_YES,

(field_1 = '0' ) as field_1_NO,

(field_2 = '0' ) as field_2_NO;

Then, on my QlikView sheet, I would like to design a Multi-box, which would then display only two fields : FIELD_1  and FIELD_2

The drop-down selection-menus for each field would have a value of either "YES" or "NO"

I am having trouble getting the logic correct.

Obviously, my script is wrong, because I need just two fields.  The script I am using generates FOUR different fields. 

How can I combine "YES" and "NO" for each field ?

Thanks.

[antoniotiman · Accepted solution]

LOAD

If(Field_1=1,'YES','NO') as Field_1,

If(Field_2=1,'YES','NO') as Field_2

From ....

[#3]

THANKS )))

This worked