topic Re: If Statement in QlikView

If Statement

Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

I am getting the below error while using the if statement. Please help me out.

select Age,

Alias,

City,

if (City = 'texas','tx',city) as [newcity],

Finisher,

Married,

Name,

Notority_Level,

wwechampion

FROM master.dbo."t_wrestlersinfo";

SQL##f - SqlState: 37000, ErrorCode: 156, ErrorMsg: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'if'.

Re: If Statement

sunny_talwar — Thu, 28 Apr 2016 19:55:55 GMT

Try this:

Table:

LOAD *,

If(City = 'texas', 'tx', city) as [newcity];

select Age,

Alias,

City,

Finisher,

Married,

Name,

Notority_Level,

wwechampion

FROM master.dbo."t_wrestlersinfo";

Re: If Statement

Thu, 28 Apr 2016 20:01:49 GMT

Hi,

As sunny mentioned but small change, else part should be "City"

Table:

LOAD *,

If(City = 'texas', 'tx', City) as [newcity];

select Age,

Alias,

City,

Finisher,

Married,

Name,

Notority_Level,

wwechampion

FROM master.dbo."t_wrestlersinfo";

--Uva

Re: If Statement

Thu, 28 Apr 2016 20:03:30 GMT

Now i am getting this error

Cannot open file 'C:\Users\hi\Desktop\master.dbo."t_wrestlersinfo"' The system cannot find the file specified.

Re: If Statement

Colin-Albert — Thu, 28 Apr 2016 20:27:52 GMT

QlikView is fully case sensitive, field names and the data is case sensitive. So city does not exist in your data but City does.

You have also mixed QlikView syntax and SQL syntax. You need to separate the SQL part of the script and the QlikView part.

Try this

Load *,

if (City = 'texas','tx',City) as [newcity] ;

Sql select Age,

Alias,

City,

Finisher,

Married,

Name,

Notority_Level,

wwechampion

FROM master.dbo."t_wrestlersinfo";

Re: If Statement

jleefjcapital — Wed, 26 Oct 2016 19:40:05 GMT

I have a similar question. I'm using this If statement --

If ([seriesid] = ' x', [value]) as [Alabama] ,

I'm trying to replace [value] with [Alabama] for all records with [seriesid] = x. Is this the correct If statement?

Re: If Statement

Colin-Albert — Wed, 02 Nov 2016 17:24:28 GMT

Hi Jessica, you need to use something like this

If([seriesid] = 'x', 'Alabama', [value]) as [value]

Remember Qlik is case sensitive so you may need to test

if(lower([seriesid]) = 'x', 'Alabama', [value]) as [value]

Re: If Statement

jleefjcapital — Wed, 02 Nov 2016 18:50:55 GMT

Thank you. This is helpful.