topic Re: Undefined function 'If' in expression in QlikView

Undefined function 'If' in expression

Anonymous — Tue, 11 Nov 2014 15:41:24 GMT

Hi guys,

I have a database I’m extracting information from using the code below

ODBC CONNECT32 TO [MS Access Database;DBQ=H:\General - Shareplan\Ad-hoc\2014\Qlikview - live\Database.mdb];

Milestones:
sql select

MilestoneDefID,
ExpectedDate,
CompletionDate,
If(MilestoneDefID = 9,[ExpectedDate],) as [9 - expected]

FROM [Milestone];

It comes up with this error though.

SQL##f - SqlState: 37000, ErrorCode: 4294964194, ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Undefined function 'If' in expression.

I suspect it’s because I’m using an IF statement with a SQL select statement but I’ve searched the net and can’t come up with a solution. Can anyone help?

Re: Undefined function 'If' in expression

Tue, 11 Nov 2014 15:43:11 GMT

Hi,

while extracting from database you won't use If statement.

Try this using preceeding load

ODBC CONNECT32 TO [MS Access Database;DBQ=H:\General - Shareplan\Ad-hoc\2014\Qlikview - live\Database.mdb];

Milestones:

**Load *,**

If(MilestoneDefID = 9,[ExpectedDate],) as [9 - expected];

sql select

MilestoneDefID,
ExpectedDate,
CompletionDate,

FROM [Milestone];

Re: Undefined function 'If' in expression

Anonymous — Tue, 11 Nov 2014 15:48:13 GMT

Thanks

Re: Undefined function 'If' in expression

Tue, 11 Nov 2014 15:48:39 GMT

Welcome 🙂

topic Re: Undefined function 'If' in expression in QlikView

Undefined function 'If' in expression

Re: Undefined function 'If' in expression

ODBC CONNECT32 TO [MS Access Database;DBQ=H:\General - Shareplan\Ad-hoc\2014\Qlikview - live\Database.mdb];

Milestones:

Load *,

If(MilestoneDefID = 9,[ExpectedDate],) as [9 - expected];

sql selectMilestoneDefID, ExpectedDate, CompletionDate, FROM [Milestone];

Re: Undefined function 'If' in expression

Re: Undefined function 'If' in expression

**Load *,**

sql select

MilestoneDefID,
ExpectedDate,
CompletionDate,

FROM [Milestone];