Loading Script converts data that was True/False to 1/0

[pnvenkat]

Hi,

I'm loading data into the Qlik Sense app from BigQuery using the following script:

[tests]:

SELECT ID, passed

FROM `db.table`;

In the original data, passed can be either True or False. After being loaded into the application, it shows up as 1 or 0. How do I change it back to True or False?

[dplr-rn]

1 and 0 is qliks boolean type.
You can try Text(passed)

[pnvenkat]

Hi,
I used the following, and it didn't work:

[tests]:

SELECT ID, Text(passed)

FROM `db.table`;

[Seyko]

Hello,

Try this following script:

[tests]:
LOAD
ID,
IF(passed=1,'True','False') AS passed;
SELECT
ID,
passed
FROM `db.table`;

Cordialy.