Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.
Thanks Gysbert!