After pulling the data from database through SQL select, the checkbox field (AUTOFLAG) is showing blank. However, if i pull the same field by different tools like R or Aginity, it gives Boolean values (True, False, NULL).
AutoFlag1:
SQL SELECT
POLID,
AUTOFLAG
FROM "Database.POLICYAUTO";
POLID | AUTOFLAG |
162 | - |
163 | - |
164 | - |
165 | - |
167 | - |
168 | - |
For me it seems it is a format issue which Qlik Sense is not able to recognize. Please help.