topic Re: How to translate TRUE/FALSE values from Excel data in QlikView

How to translate TRUE/FALSE values from Excel data

Thu, 15 Oct 2015 13:10:21 GMT

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?

m_woolf — Thu, 15 Oct 2015 13:53:41 GMT

in script:

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

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

sunny_talwar — Thu, 15 Oct 2015 13:54:29 GMT

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

Qrishna — Thu, 15 Oct 2015 13:56:04 GMT

This way?

Thu, 15 Oct 2015 13:57:25 GMT

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 — Thu, 15 Oct 2015 14:01:27 GMT

A quicker way to load than nested IF statements try:

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

Thu, 15 Oct 2015 14:31:23 GMT

Thanks for all your help guys.

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

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