topic If statement in QlikView

If statement

Wed, 13 Jun 2012 14:40:12 GMT

I want to use an If statement in my script to change values in my "Active" column from 'No' to 1 and "yes" to zero.

Been trying but I must be doing something wrong.

Thanks!

Re: If statement

Wed, 13 Jun 2012 14:42:35 GMT

if((Active = 'No',1,0) AS ActiveInt

This statement assumes you are not dealing with a 3 state boolean (Yes, No, Null)

Re: If statement

Wed, 13 Jun 2012 14:47:46 GMT

Where in the script is it supposed to go?

Re: If statement

Wed, 13 Jun 2012 14:49:12 GMT

Just put it as a new field in your load script

Re: If statement

mphekin12 — Wed, 13 Jun 2012 14:49:13 GMT

Something like this may work:

if(Active='No',1,

if(Active='Yes',0,'')

) AS ActiveFlag

Re: If statement

Wed, 13 Jun 2012 15:00:09 GMT

I put it in and it loads but does not change the text to the specified numbers. Not sure why it ran then? Any other ideas?

Re: If statement

mphekin12 — Wed, 13 Jun 2012 15:01:26 GMT

Can you post a sample app?

Re: If statement

Wed, 13 Jun 2012 15:04:28 GMT

Are you trying to do this in the UI or backend can you give us a file to work with?

Re: If statement

CELAMBARASAN — Wed, 13 Jun 2012 15:08:48 GMT

Hi,

Check with this

Load

Active,

Pick(MixMatch(Trim(Active), 'Yes', 'No'), 1, 0) AS ActiveFlag

FROM

Celambarasan

Re: If statement

Wed, 13 Jun 2012 15:11:35 GMT

LOAD

"User_ID",
"User_Name",
"First_Name",
"Last_Name",
(Inactive) as Active,
SSO,
1 as MFCount,
if(Inactive='No',1,
if(Inactive='Yes',0,'')) AS ActiveFlag;

Re: If statement

Wed, 13 Jun 2012 15:13:52 GMT

LOAD "User_ID",
"User_Name",
"First_Name",
"Last_Name",
(Inactive) as Active,
SSO,
1 as MFCount,
if((Inactive) ='No',1,0) AS ActiveFlag;

SQL SELECT * FROM IDONTKNOWWHAT;

Re: If statement

CELAMBARASAN — Wed, 13 Jun 2012 15:25:23 GMT

Hi,

Check with this

LOAD

"User_ID",
"User_Name",
"First_Name",
"Last_Name",
(Inactive) as Active,
SSO,
1 as MFCount,

Pick(MixMatch(Trim(Inactive), 'Yes', 'No'), 1, 0) AS ActiveFlag;

Re: If statement

Wed, 13 Jun 2012 15:27:54 GMT

I got it to work. Thank you very much for you patience! I'm new at this!