Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Blank Fields in Variable

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,

1 Solution

Accepted Solutions
jyothish8807
Master II
Master II

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

Best Regards,
KC

View solution in original post

8 Replies
alexandros17

write t and f with apex:

REL_IND='t' ....

Let me know

mjayachandran
Creator II
Creator II

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)

Not applicable

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
MVP
MVP

if you only have 3 values

t                                --> yes

other (f or blank)      --> no

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

simenkg
Partner
Partner

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

jyothish8807
Master II
Master II

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

Best Regards,
KC

View solution in original post

Not applicable

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

Not applicable

Those worked perfect. thank you guys so much