][SQL Server]'mixmatch' is not a recognized built-in function name.

[#1]

Get error msg:

SQL##f - SqlState: 37000, ErrorCode: 195, ErrorMsg: [Microsoft][ODBC SQL Server Driver][SQL Server]'mixmatch' is not a recognized built-in function name.

when executing the following script:

MainFacData:

SQL SELECT

Customer,

"Snapshot_Date"

if(mixmatch(month("Snapshot_Date"),'Jan','Feb','Mar'),'1Q',

if(mixmatch(month("Snapshot_Date"),'Apr','May','Jun'),'2Q',

if(mixmatch(month("Snapshot_Date"),'Jul','Aug','Sep'),'3Q','4Q'))) as Quarter

FROM "FISS_DM".Risk."RMD_Aggr_FISS_Facility"

Anyone could help?

[Anonymous · Accepted solution]

Hi Alex,

Whatever you put between the SQL and the ; will be sent as a query to the database connection that you have open.

You can't use QlikView functions as mixmatch as the database will not understand this syntax and throw the above error back to you. Only use proper syntax that is accepted by your database, in this case, T-SQL for SQL Server.

QlikView functions can be applied in a load statement that uses the SQL statement as a data source like:

Load

     A,     <- Mixmatch can go in here

     B;

SQL Select

     A,

     B

From tableX;