Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

BigQuery connector: String reference not set to an instance of a string

Hi everyone,

I've been using Qlikview's BigQuery connector to retrieve data from tables in bigquery datasets.

Here's a very simple sample query:

CUSTOM CONNECT TO...

tableA:

SQL SELECT *

FROM tableA;

However I noticed that whenever a string type field contains null values, Qlikview throws a 'String reference not set to an instance of a string'.  Is there anyway around this, besides explicitly excluding rows with null values in the query?

Any help would be much appreciated.

1 Reply
Not applicable

Hi i Know this is an old thread but i am surprised no one else is experiancing this issue. when tested with the qvsource (BETA) big query connector all worked well with null values. though it does look like this connector has issues. can we confirm if there is still a bug.

we are trying to load GA anayltics data through big query. it works when a not null field set is collected but we cannot select all fields?.