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

Tue, 28 Jul 2015 07:47:49 GMT

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.

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

antoniotiman — Tue, 28 Jul 2015 07:54:34 GMT

LOAD

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

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

From ....

Tue, 28 Jul 2015 08:25:41 GMT

THANKS )))

This worked