Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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
write t and f with apex:
REL_IND='t' ....
Let me know
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)
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
if you only have 3 values
t --> yes
other (f or blank) --> no
if (REL_IND=t,'yes', 'no') as Release
if(REL_IND = 'f' or len(trim(REL_IND))=0,'Yes',if(REL_IND='t','No))
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
if(REL_IND='t','yes','no') as release
Those worked perfect. thank you guys so much