topic Re: Direct Query Native quoting in QlikView

Direct Query Native quoting

rbecher — Thu, 16 Apr 2015 08:14:43 GMT

Hi,

how can we quote the native string? This doesn't work (double single quotes):

DIRECT QUERY

DIMENSION

NATIVE('to_date(ERDAT,''YYYYMMDD'')') as ERDAT

...

- Ralf

Re: Direct Query Native quoting

rajeshvaswani77 — Fri, 29 Apr 2016 12:28:49 GMT

Hi Ralf,

Finally did the quote work.

Please let know.

I am facing the same issue.

Thanks,

Rajesh Vaswani

Re: Direct Query Native quoting

florentina_doga — Fri, 29 Apr 2016 13:39:12 GMT

try this exemple

DIRECT QUERY

dimension

product

measure

value

FROM dbo."table";

Re: Direct Query Native quoting

rbecher — Fri, 29 Apr 2016 13:51:04 GMT

How your answer is related to my question?

Re: Direct Query Native quoting

petter — Sat, 30 Apr 2016 22:37:09 GMT

Tried this NATIVE function with DIRECT QUERY on an Oracle database and it worked well for me. Which version and service release did you get a problem with? How is it "not working" for you? Error message or null values or what?

Re: Direct Query Native quoting

rbecher — Sun, 01 May 2016 00:02:19 GMT

And how do you qoute inside of NATIVE?

My last try was a year ago against SAP HANA..

Re: Direct Query Native quoting

petter — Sun, 01 May 2016 00:09:24 GMT

Exactly like you did with two consequtive single quotes. But I assumed it was Oracle since you didn't mention which database you used. I tested this with QlikView 11.20 SR12.

Re: Direct Query Native quoting

framacdev — Sat, 10 Aug 2019 11:21:15 GMT

I know the post is a little bit old but I also ran into the same issue a few days ago.

I needed a string url within my Direct Query to extract pictures from a website.

I resolved the issue adding two variables to the Qlik Sense script.

I am working with Qlik Sense April 2019 Patch 1 and ElevateDB database.

Here is the script sample:

LET vWebsiteURL = chr(39) & 'https://mywebsite.com/img/' & chr(39);
LET vWebsitePIC = chr(39) & '.png' & chr(39);

LIB CONNECT TO 'ODBC Connection (new_user)';

invoice:
DIRECT QUERY
DIMENSION

SalesRep,
NATIVE('$(vWebsiteURL) + SalesRep + $(vWebsitePIC)') As Picture
MEASURE
SubTotal
FROM "Database".orders
;