topic Re: Blank Fields in Variable in QlikView

Blank Fields in Variable

Mon, 06 Oct 2014 15:19:56 GMT

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,

" "

REL_IND

if (REL_IND=t,'yes',

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

Re: Blank Fields in Variable

alexandros17 — Mon, 06 Oct 2014 15:22:49 GMT

write t and f with apex:

REL_IND='t' ....

Let me know

Re: Blank Fields in Variable

mjayachandran — Mon, 06 Oct 2014 15:27:48 GMT

Not sure If I understood ur question right.

Is the below u r looking for ?

REL_IND,

" "

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)

Re: Blank Fields in Variable

Mon, 06 Oct 2014 16:13:27 GMT

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

Re: Blank Fields in Variable

maxgro — Mon, 06 Oct 2014 17:36:53 GMT

if you only have 3 values

t --> yes

other (f or blank) --> no

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

Re: Blank Fields in Variable

simenkg — Mon, 06 Oct 2014 17:43:00 GMT

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

Re: Blank Fields in Variable

jyothish8807 — Mon, 06 Oct 2014 17:45:13 GMT

Hi Freddie,

simply write:

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

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

Regards

Re: Blank Fields in Variable

Mon, 06 Oct 2014 17:51:46 GMT

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

Re: Blank Fields in Variable

Mon, 06 Oct 2014 19:01:51 GMT

Those worked perfect. thank you guys so much