topic Re: How do I recode values of my variables? in QlikView

How do I recode values of my variables?

Wed, 25 Nov 2020 16:16:04 GMT

Hello!

I have a variable ("sex") and the values are numeric - 1 for Male, 2 for Female. I want them to display in my table as the strings "Male" and "Female", not 1's and 2's. I have found a lot of guidance as to renaming the variable, but what I want to do is relabel the values of my variable. Is there a way to do this with script (or even point-and-click), and if so, where would I put it?

Thank you!

Re: How do I recode values of my variables?

MK_QSL — Tue, 29 Nov 2016 19:43:44 GMT

What do you mean by recode value?

Re: How do I recode values of my variables?

Tue, 29 Nov 2016 19:45:15 GMT

I guess I am not using the correct term. I wan to "recode" the 1's and 2's as "Male" and "Female". Does that make sense?

Re: How do I recode values of my variables?

muniyandi — Tue, 29 Nov 2016 19:46:38 GMT

in the table you have write if condition like : if ( sex =1 ,'Male','Female') as Sex

Re: How do I recode values of my variables?

Tue, 29 Nov 2016 19:47:01 GMT

I am more familiar with Tableau - in Tableau, I would be able to create a calculated field that said something along the lines of [if sex = 1 then "male" elseif sex = 2 then "female" else null] and the 1's and 2's would display as "male" and "female". I am wondering if there is something similar I can do in QlikView?

Re: How do I recode values of my variables?

MK_QSL — Tue, 29 Nov 2016 19:47:15 GMT

I think you mean you have fieldname Sex and having values 1 and 2

You can do something like below in script.

IF(Sex = 1, 'Male', 'Female') as Sex

Re: How do I recode values of my variables?

Tue, 29 Nov 2016 20:00:09 GMT

Hmm...keep getting red squiggly lines under 'Male' and 'Female'.

Re: How do I recode values of my variables?

MK_QSL — Tue, 29 Nov 2016 20:02:24 GMT

may be due to fieldname...

make note that Sex, sex and SEX all are different fields..

So use the correct one.

Re: How do I recode values of my variables?

Tue, 29 Nov 2016 20:36:44 GMT

That works to change the value labels for charts, but why won't it work for a Table Box?

Re: How do I recode values of my variables?

rupamjyotidas — Tue, 29 Nov 2016 20:39:16 GMT

You need to make the change in Script and use the New field in Table Box.

IF(Sx = 1, 'Male', IF(Sx = 2,'Female','NA')) as Sx2

Re: How do I recode values of my variables?

rupamjyotidas — Tue, 29 Nov 2016 20:45:44 GMT

You can't write conditions for field in a TABLE Box. You can use a Straight Table instead.

Re: How do I recode values of my variables?

Tue, 29 Nov 2016 20:59:37 GMT

Thank you!!