Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
LOAD
If(Field_1=1,'YES','NO') as Field_1,
If(Field_2=1,'YES','NO') as Field_2
From ....
LOAD
If(Field_1=1,'YES','NO') as Field_1,
If(Field_2=1,'YES','NO') as Field_2
From ....
THANKS )))
This worked