topic Re: Boolean values - Looking for alternative options and results! in QlikView

Boolean values - Looking for alternative options and results!

Mon, 01 Apr 2013 14:23:43 GMT

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?

Re: Boolean values - Looking for alternative options and results!

Gysbert_Wassenaar — Mon, 01 Apr 2013 14:55:45 GMT

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.

Re: Boolean values - Looking for alternative options and results!

Mon, 01 Apr 2013 15:13:55 GMT

Thanks Gysbert!