topic Re: extracting field with parentheses in QlikView

extracting field with parentheses

Mon, 26 Jan 2026 18:19:17 GMT

Hi everybody,

I'm extracting a field from database with the name Cost Amount (Actual) but it gives me an error in script,

here is my query

SELECT [Cost Amount (Actual)] as prix

FROM [EKG2013].[dbo].[FAD2014$Item Ledger Entry];

regards.

Re: extracting field with parentheses

giakoum — Fri, 14 Feb 2014 08:25:19 GMT

is it an oracle db?

SQL SELECT "Cost Amount (Actual)" as prix

FROM [EKG2013].[dbo].[FAD2014$Item Ledger Entry];

Re: extracting field with parentheses

Fri, 14 Feb 2014 08:26:40 GMT

no loannis it's an sqlserver database

Re: extracting field with parentheses

hic — Fri, 14 Feb 2014 08:27:12 GMT

The SELECT statement is not evaluated by QlikView. It is evaluated by the ODBC driver or OLEDB provider. So, without the error message it is impossible to say what has gone wrong. Perhaps try using double quotes:

SELECT "Cost Amount (Actual)" as prix

FROM [EKG2013].[dbo].[FAD2014$Item Ledger Entry];

HIC

Re: extracting field with parentheses

giakoum — Fri, 14 Feb 2014 08:28:47 GMT

it should work for mssql as well. If you try to select a field with no spaces, does it work?

Re: extracting field with parentheses

Fri, 14 Feb 2014 08:32:51 GMT

no either mr henric , it tells me that the field name is incorrect

and for information i use [] and it works for the other queries for fields without parentheses.

Re: extracting field with parentheses

Fri, 14 Feb 2014 08:33:25 GMT

no it deosn't 😕

Re: extracting field with parentheses

Fri, 14 Feb 2014 08:44:23 GMT

Try using precedent load, something like this:

LOAD

"Cost Amount (Actual)";

SQL SELECT *

FROM [EKG2013].[dbo].[FAD2014$Item Ledger Entry];

Re: extracting field with parentheses

hic — Fri, 14 Feb 2014 08:45:43 GMT

There are many things that may have gone wrong here. But first - if it says that the field name is incorrect, then it is incorrect. So...

One possibility is that you have written the field name with soft blank spaces - char(32) - but it is in fact defined using hard blank spaces - char(160). Another possibility is that the library name is incorrect.

Either way, I would try to load SELECT * FROM ... to see which fields I get.

HIC

Re: extracting field with parentheses

Fri, 14 Feb 2014 08:46:47 GMT

As Henric and Ioannis, I would have said the double quotes. Double quote and square brackets ? SELECT "[ Your field (xxx)]" as Prix ?

If you are stuck, create a View in SQL Sever with the good name and use it from QlikView

Fabrice

Re: extracting field with parentheses

manojkulkarni — Fri, 14 Feb 2014 08:48:04 GMT

you need to use fields in doule quote having any special characters

Re: extracting field with parentheses

Fri, 14 Feb 2014 09:32:29 GMT

it appeared that the field is calculated in navision and doesn't exist in sqlserver

thanks for all