Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Thanks for all your help guys.
I got it working with this in the script.....
If([New Install?] = -1, 'TRUE', 'FALSE') as [New Install?]
in script:
if([New Install] = -1,'TRUE',
if(([New Install] = 0,'FALSE')) as [New Install],
Seems to be working fine for me. May be add Text() function for New Install?
This way?
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.
A quicker way to load than nested IF statements try:
pick(match([New Install], -1, 0), 'TRUE','FALSE')
Thanks for all your help guys.
I got it working with this in the script.....
If([New Install?] = -1, 'TRUE', 'FALSE') as [New Install?]