Blank Fields in Variable

[#1]

Hello, I was wondering if I could get some help. I am still learning Qlikview, and cant figure something out. I have a filed that has 3 values t , f , and blank " ". I want to combine Blank and f, and remane the field to Release. I cant get my code to work, im sure im not doing it right. Any help would be appreciated.

REL_IND,

t

f

" "

REL_IND

     if (REL_IND=t,'yes',

     if (REL_IND=f, " " , 'No' )) as Release,

[alexandros17]

write t and f with apex:

REL_IND='t' ....

Let me know

[mjayachandran]

Not sure If I understood ur question right.

Is the below u r looking for ?

REL_IND,

t

f

" "

REL_IND

     if (REL_IND=t,'yes',

          if (REL_IND=f,'No' ,' ')) as Release

So if Rel_IND = t then Release will be 'Yes'

Else

Rel_IND = f then Release will be 'No'

Else

Release will be ' ' ( Blank)

[#4]

Sorry, maybe I didnt explainit right. I want f and blank be a combined value called "no'

Then only two choices I want yes and No.

No = f + " "(Blank)

Yes = t

hope this helps.

thanks

[maxgro]

if you only have 3 values

t                                --> yes

other (f or blank)      --> no

if (REL_IND=t,'yes', 'no') as Release

[simenkg]

if(REL_IND = 'f' or len(trim(REL_IND))=0,'Yes',if(REL_IND='t','No))

[jyothish8807 · Accepted solution]

Hi Freddie,

simply write:

if(REL_IND='t','Yes','No') as Release

This expression will say no to all values other than 't'.

Regards

KC

[#8]

if(REL_IND='t','yes','no') as release

[#9]

Those worked perfect. thank you guys so much