Boolean values - Looking for alternative options and results!

[#1]

Looking for better alternative for working with Boolean values.  I am using SQL select, not working with QVD.

Script:

SELECT

OrderHed.OrderNum,

OrderHed.Checkbox01 as 'SymTS' // 0 or 1

FROM "SUB_SMI".dbo.OrderHed;

QV Listbox Properties:

 

QV ListBox on Sheet:  Why does the value 1 TRUE change to FALSE when value 0 FALSE is selected?

QV Selected on Sheet:  Would prefer the Value "TRUE" or "FALSE" to appear.  Can this be done?

[Gysbert_Wassenaar · Accepted solution]

Qlikview doesn't have a boolean type. So your boolean gets loaded into qlikview as a number. If a number is used as a condition in for example an if statement then any number other than 0 is true and 0 itself is evaluated as false.

You could use the dual value to give it a text as well as a numeric value:

dual(if(OrderHed.Checkbox01,'True','False'), OrderHed.Checkbox01) as SymTS

This way SymTS will shown as True or False text values.

[#3]

Thanks Gysbert!