Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Ralf,
Finally did the quote work.
Please let know.
I am facing the same issue.
Thanks,
Rajesh Vaswani
try this exemple
DIRECT QUERY
dimension
product
measure
value
FROM dbo."table";
How your answer is related to my question?
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?
And how do you qoute inside of NATIVE?
My last try was a year ago against SAP HANA..
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.
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
;