How to translate TRUE/FALSE values from Excel data

[#1]

Hello again!

I have some Excel data that looks something similar to the following.  When I load this data into Qlikview my TRUE/FALSE values tranlsate to 0 or -1.

I actually want the presentation in QV to show "TRUE" or "FALSE"  or even YES or NO.

What am I doing wrong here?

Ref	New Install?
SLTN00001	TRUE
SLTN00002	TRUE
SLTN00003	FALSE
SLTN00004	FALSE

[m_woolf]

in script:

if([New Install] = -1,'TRUE',

     if(([New Install] = 0,'FALSE')) as [New Install],

[sunny_talwar]

Seems to be working fine for me. May be add Text() function for New Install?

[krishna_2644]

This way?

[#5]

Hi

in the script try

if ([new install]='TRUE', 'True','False') as [new install value]

if it not work, please post the sample excle & qvw files.

[ogster1974]

A quicker way to load than nested IF statements try:

pick(match([New Install], -1, 0), 'TRUE','FALSE')

[#7 · Accepted solution]

Thanks for all your help guys.

I got it working with this in the script.....

If([New Install?] = -1, 'TRUE', 'FALSE') as [New Install?]